cameraguy Posted February 19, 2007 Share Posted February 19, 2007 Hi i run a camera website and am having en error where whenever i go to the shopping cart i see an error on the bottom of the page(shown below). i looked in my shopping cart file and dont even see those lines of code in it and am 100% clueless what to do to get rid of it any help would mean the world to me thanks! "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 'GROUP BY s.name' at line 1 SELECT round( sum( p.products_price * rate * cb.customers_basket_quantity ) , 2 ) AS cost, s.name FROM customers_basket cb INNER JOIN products p ON p.products_id = cb.products_id INNER JOIN shipping_methods s ON s.products_shipping_class_id = p.products_shipping_class_id WHERE cb.customers_id = GROUP BY s.name" Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.