ccrevcypsys Posted September 20, 2007 Share Posted September 20, 2007 MySQL Error Occured n1064: 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 'JOIN cc_CubeCart_customer ON cc_CubeCart_inventory.customer_id=cc_CubeCart_custo' at line 1 n QUERY = SELECT * FROM cc_CubeCa t_i ve to y WHERE RIGHT JOIN cc_CubeCa t_custome ON cc_CubeCa t_i ve to y.custome _id=cc_CubeCa t_custome .custome _id cc_CubeCa t_i ve to y.custome _id=custome _id AND deleted = 0 AND custome _id !=31 AND cat_id=43 ORDER BY popula ity DESC LIMIT 9 n Here is the error that i get this was just working 2 seconds ago but now it isnt? here is the code $genre_query = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_inventory WHERE RIGHT JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_inventory.customer_id=".$glob['dbprefix']."CubeCart_customer.customer_id ".$glob['dbprefix']."CubeCart_inventory.customer_id=customer_id AND deleted = 0 AND customer_id !=".$prodArray[0]['customer_id']." AND cat_id=".$prodArray[0]['cat_id']." ORDER BY popularity DESC LIMIT 9"); Quote Link to comment Share on other sites More sharing options...
Jessica Posted September 20, 2007 Share Posted September 20, 2007 Why do you have all of these spaces in the table and column names? 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.