wizard0522 Posted March 26, 2008 Posted March 26, 2008 I am getting this error in mysql: 064 - 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, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '3' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20
burt Posted March 26, 2008 Posted March 26, 2008 This has been asked and answered loads; http://www.oscommerce.com/forums/index.php?sho...&pid=625897 The forum needs sticky posts ;)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.