VKBrookeWilliams Posted October 15, 2005 Share Posted October 15, 2005 How do I add product to the specials module in the admin? Everytime I click on it, it says: 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 '-20, 20' at line 1 select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20 Does anyone know what I should do? Link to comment Share on other sites More sharing options...
wheeloftime Posted October 15, 2005 Share Posted October 15, 2005 How do I add product to the specials module in the admin? Everytime I click on it, it says: 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 '-20, 20' at line 1 select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20 Does anyone know what I should do? Read here Scroll all the way down and look at the last post. Link to comment Share on other sites More sharing options...
VKBrookeWilliams Posted October 15, 2005 Author Share Posted October 15, 2005 Read hereScroll all the way down and look at the last post. THANK YOU SO MUCH!!! :D 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.