Jump to content

[SOLVED] wtf it was working then stopped?


ccrevcypsys

Recommended Posts

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");

Link to comment
https://forums.phpfreaks.com/topic/70027-solved-wtf-it-was-working-then-stopped/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.