Duplicates subcats when choosing manufacturer

[keoga]

Hello this is a little hard to explain, but I'll try.

 

If you have e.g like this: different main categories and same subcategories in two different places like :

 

Electronics>binoculars

Hiking>binoculars

 

and you then choose from the manufacturers list (the binoculars manufacturer) then you are going to end with a show: dropdown list with a duplicate in like

 

show: binoculars

binoculars

 

I'm sure that it should be easy changing the code in catalog/index.php

 

About line:246

 

Could someone help me to solve this little Bug?

 

if (PRODUCT_LIST_FILTER > 0) {
    if (isset($HTTP_GET_VARS['manufacturers_id'])) {
      $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

 

 

 

Thankyou!