Bit_dippy Posted October 25, 2007 Share Posted October 25, 2007 Hi, I realise that this problem has been mentioned before but I am very new to this and didn't understand how to solve the problem. Like I said I'm very new. Please could you help me with the following error that I get: 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 ') and pd.language_id=1' at line 1 select p.products_id, pd.products_name, p.products_image2, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in() and pd.language_id=1 I notice in a previous mention of this that you advise that it is to do with the empty () but I didn't understand how to rectify it. Please could you advise? Many thanks. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.