Guest Posted January 21, 2007 Share Posted January 21, 2007 My specials section is empty (no product listed) and when I try to add something the speical in the admin screen shows this code... 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 get anyone help me out to get this fix? Thanks! Link to comment Share on other sites More sharing options...
Guest Posted January 21, 2007 Share Posted January 21, 2007 help :'( Link to comment Share on other sites More sharing options...
jasonabc Posted January 21, 2007 Share Posted January 21, 2007 http://www.oscommerce.com/forums/index.php?showtopic=144095 Jason My Contributions: Paypal Payflow PRO | Rollover Category Images | Authorize.net Invoice Number Fix Link to comment Share on other sites More sharing options...
Guest Posted January 22, 2007 Share Posted January 22, 2007 http://www.oscommerce.com/forums/index.php?showtopic=144095 Thank you! You guys are awesome! 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.