mleeney Posted August 20, 2008 Share Posted August 20, 2008 Hi When i select sanyo from my manafacturer dropdown I have 22 items in the list. The first page shows fine when I select page 2 i get the following error. 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 'order by pd.products_name limit 20, 20' at line 1 select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '10' order by order by pd.products_name limit 20, 20 you can see the error at http://www.projectorsandparts.co.uk/index....t=2a&page=2 The highlighted part of the query doesn't seem right to me. I am using a template version of oscommerce by 7dana i have updated split_page_results.php in includes/classes and admin/includes/classes with the current release but that hasn't worked. Help would be appreciated. Thanks Martin Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.