Guest Posted March 14, 2006 Posted March 14, 2006 Hi! can somone tell me where to find 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 'limit 0, 12' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '2' and ot.class = 'ot_total' order by limit 0, 12 Thanks!
Guest Posted March 14, 2006 Posted March 14, 2006 http://www.oscommerce.com/forums/index.php?sho...&hl=1064+syntax The_Bear
Guest Posted March 14, 2006 Posted March 14, 2006 Hi thanks for the link. i checked it however and these changes have already been made. I also have a problem with the fact that my product listing does not 'split' onto another page when it reaches the max number of products per page variable. Any ideas where and what this is? Unfortunatly i am not a php programmer nor do i have time to learn to be. If you have any advice on the subject i would be much appreciative! thanks!
Guest Posted March 14, 2006 Posted March 14, 2006 in fact could someone just send me a working version of both the admin and catalog versions of spit_page_results.php if it is easier. I have been trying to address this problem for several months now and im am very eger to get this sorted once and for all. thanks!
Guest Posted March 14, 2006 Posted March 14, 2006 Just download a copy of osCommerce here and use what you need The_Bear
Recommended Posts
Archived
This topic is now archived and is closed to further replies.