thistledonicely Posted January 3, 2006 Share Posted January 3, 2006 Hi everyone. Brand new member here and not what you might call technically gifted, although I am keen to "give it a go" I am in the process of creating a new store and was changing the products in my "specials" category. There were already some products in there so I removed them however before I could add a new product I received this message - 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 '-6, 6' at line 1 select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -6, 6 [TEP STOP] What do I need to do? I can't add or do anything in this category at the moment! Link to comment Share on other sites More sharing options...
♥Vger Posted January 3, 2006 Share Posted January 3, 2006 Read the "1064" link below my name. Vger Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.