hoangk800

I selected specs group but specs result is a loop, ex: Group specs 1: Specs 1: detail 1 Specs 1: detail 1 Specs 1: detail 1 Specs 2: detail 2 Specs 2: detail 2 Specs 2: detail 2 My DB code: $specifications_query_raw = "select ps.specification, s.filter_display, s.enter_values, sd.specification_name, sd.specification_prefix, sd.specification_suffix from " . TABLE_PRODUCTS_SPECIFICATIONS . " ps, " . TABLE_SPECIFICATION . " s, " . TABLE_SPECIFICATION_DESCRIPTION . " sd, " . TABLE_SPECIFICATION_GROUPS . " sg, " . TABLE_SPECIFICATIONS_TO_CATEGORIES . " sg2c where sg.show_products = 'True' and s.show_products = 'True' and ps.specifications_id = sd.specifications_id and sd.specifications_id = s.specifications_id and s.specification_group_id = sg.specification_group_id and sg.specification_group_id = '". (int) $spec_group['specification_group_id'] ."' and ps.products_id = '" . (int) $_GET['products_id'] . "' and sd.language_id = '" . (int) $languages_id . "' and ps.language_id = '" . (int) $languages_id . "' order by s.specification_sort_order, sd.specification_name "; Please help me to fix this error. Tks,

Hi, Your contribution is very well. But I want to change display at products_info.php as: At the Specs tab, I want display the same specs in each group name (ex: - Group name 1 -- Specs 1: specs 1 detail -- Specs 2: specs 2 detail - Group name 2 -- Specs 1: specs 1 detail -- Specs 2: specs 2 detail) *default is: Specs 1, Specs 2,.... - not included in a Group Can you help me to make this change? Thanks & best regards,

Hi, Can you help me how to add parent dir to each sections as: mysite.com/cat1-subcat1-c-3.html -> mysite.com/productlist/cat1-subcat1-c-3.html mysite.com/cat1-subcat2-c-4.html -> mysite.com/productlist/cat1-subcat1-c-4.html mysite.com/prod1-p-1.html -> mysite.com/productdetails/prod1-p-1.html mysite.com/prod2-p-2.html -> mysite.com/productdetails/prod2-p-2.html Same with Articles, add /articlelist/ and /articledetails/ Thanks & best regards