dohnut2004 Posted March 23, 2005 Share Posted March 23, 2005 when i go to specials i get 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 '-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 anyone know what it is and how to fix it please dohnut thanks in advance Link to comment Share on other sites More sharing options...
Guest Posted March 23, 2005 Share Posted March 23, 2005 You solution is at http://www.oscommerce.com/community/bugs,1...2B%28General%29 Read from the bottom to the top and pay extra attention to Peter Kaminski's solutions. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.