Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

error in SQL syntax


Guest

Recommended Posts

Posted

first of all: happy 2005!

Second: i start with a problem:

 

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

 

This info i get when i go to the Specials function in my admin. I have no clue how to fix this problem. Anyone who had this mistake before or anyone who knows how to fix this?

 

Avantia

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...