You have an error in your SQL syntax

[devan]

Hi, I am getting the following error in my UPDATE query : 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 'WHERE `productId`='1143'' at line 12

 

My code :

 

  $sqlEdit = "UPDATE CubeCart_inventory SET `productCode`='$prodcode',
										`quantity`='$prodqsa',
										`description`='$proddes', 
										`image`='$imagesaveme2',
										`price`='$prodsell',
										`name`='$prodtitle', 
										`cat_id`='$category',
										`sale_price`='$prodsale',
										`stock_level`='$prodqty', 
										`Prod_Condition`='$prodcon', 
										`Prod_Waiting`='$prodperiod',
									WHERE `productId`='$prodid'";
$result = @mysql_query($sqlEdit);

 

What might be the problem ? MySQL is saying line 12 is wrong : This Line : WHERE `productId`='$prodid'";

 

please help! 

[joel24]

you don't need a comma after the last line

Prod_Waiting`='$prodperiod', #remove this comma.
									WHERE

[devan]

EXCELLENT, thank you so much !!!!