Array
(
    [main_page] => part_finder_productlist
    [maker] => rolls royce
    [catg] => 43-replacement hid ballast
    [disp_order] => 6
)

Shop By Brand

Rolls Royce

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY m.manufacturers_name, m.manufacturers_id' at line 1
in:
[SELECT COUNT(*) as prod_qty, m.manufacturers_name, m.manufacturers_id FROM products p, manufacturers m WHERE p.manufacturers_id = m.manufacturers_id AND p.products_id IN () GROUP BY m.manufacturers_name, m.manufacturers_id]