ecshop 电子商务系统中，在分类列表页面，可以调用分类所属商品所在的品牌，因此可以通过品牌筛选来达到搜索商品的目的，但是如何将品牌名称替换成品牌LOGO。下面将结合程序，来阐述。

    1：category.php中。修改下面代码

    $sql = "SELECT b.brand_id, b.brand_name,b.brand_logo, COUNT(*) AS goods_num ".
            "FROM " . $GLOBALS[‘ecs‘]->table(‘brand‘) . "AS b, ".
                $GLOBALS[‘ecs‘]->table(‘goods‘) . " AS g LEFT JOIN ". $GLOBALS[‘ecs‘]->table(‘goods_cat‘) . " AS gc ON g.goods_id = gc.goods_id " .
            "WHERE g.brand_id = b.brand_id AND ($children OR " . ‘gc.cat_id ‘ . db_create_in(array_unique(array_merge(array($cat_id), array_keys(cat_list($cat_id, 0, false))))) . ") AND b.is_show = 1 " .
            " AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".
            "GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY b.sort_order, b.brand_id ASC";

2:category.dwt中

    <!--{foreach from=$brands item=brand}-->
      <!-- {if $brand.selected} -->
      <span><img src="/data\brandlogo\{$brand.brand_logo}"></span>
      <!-- {else} -->
      <a href="/{$brand.url}"><img src="/data\brandlogo\{$brand.brand_logo}"></a>&nbsp;
      <!-- {/if} -->
     <!--{/foreach}-->