Search:


£  

SELECT options2.ID as optionid, options1.ID as valueid, options2.title as optiontitle, options1.title as optionvalue, shop_product_options.price FROM shop_options as options1, shop_options as options2, shop_product_options WHERE shop_product_options.prodid = AND options1.iscustom = 1 AND options1.ID = shop_product_options.optid AND options1.parentcat_INC = options2.ID ORDER BY optiontitle,optionvalue

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 'AND options1.iscustom = 1 AND options1.ID = shop_product_options.optid AND optio' at line 1