4 Sep 2009, 5:29 AM
Zen Follower
- Join Date:
- Jul 2008
- Posts:
- 139
- Plugin Contributions:
- 0
Error message 1064 you have an error in your sql syntax
I get a 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 '' at line 11
in:
[select p.products_id, p.products_image from zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p where opa.products_id = '108' and opa.orders_id = opb.orders_id and opb.products_id != '108' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit ]
How and where do I correct this?