Guest pcupgradeltd Posted December 3, 2006 Share Posted December 3, 2006 I get this error when click on sale items tab MySQL Error Occured 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 price ASC LIMIT 0, 10' at line 1 QUERY = SELECT * FROM CubeCart_inventory WHERE ORDER BY price ASC I tried searching, is it a known bug? Thanks Quote Link to comment Share on other sites More sharing options...
roban Posted December 3, 2006 Share Posted December 3, 2006 Nope not a CC bug. It's all yours. Quote Link to comment Share on other sites More sharing options...
convict Posted December 4, 2006 Share Posted December 4, 2006 I get this error when click on sale items tab MySQL Error Occured 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 price ASC LIMIT 0, 10' at line 1 QUERY = SELECT * FROM CubeCart_inventory WHERE ORDER BY price ASC I tried searching, is it a known bug? ThanksYou use some php varible in the SQL question probably which is empty. Missing condition WHERE. Just remove WHERE word in SQL question to see 10 lowest price products. Dont know if this is what you want to show. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.