ecshop首页获取某个商品分类下的商品品牌列表

2016-06-13 13:05 来源:www.chinab4c.com 作者:ecshop专家

0) ? ' AND ' . get_children($cat) : ''; $sql = "SELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(g.goods_id) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag ".  "FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".   $GLOBALS['ecs']->table('goods') . " AS g ". "WHERE g.brand_id = b.brand_id $children " .    "GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC"; $row = $GLOBALS['db']->getAll($sql);  foreach ($row AS $key => $val)  {  $row[$key]['url'] = build_uri($app, array('cid' => $cat, 'bid' => $val['brand_id']), $val['brand_name']);  }        return $row;       } ?>       模板:  

  • {$brandCat.brand_name}
  •