Guest Posted January 27, 2005 Share Posted January 27, 2005 I have this errothat pops up and i was wondering if it was related to PHP5. this is waht 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 '-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 I get this error on about a dozen pages. It only shows when the page i'm looking at is trying to list something that there are not any of. For example i deleted all of the Special off my new install and when the last one was gone i got that error. I does it on a few other pages too. This is weird. I just don't get it. Because of the error i can't add more of what ever i don't have so i'm sort of screwed. Every thing else works just fine though. What's wrong? :blink: Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.