Syntax Error

[jakeruston]

Hi,

 

I'm trying to run a MySQL Query:

 

$update = "UPDATE `user` SET `weight` = 'weight' + $weight WHERE `username` = '$user'";

mysql_query($update) or die(mysql_error());

 

I get this error:

 

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 `username` = ''' at line 1

 

Any idea of why?

[Orionsbelter]

well first the string should be

 

$update = "UPDATE `user` SET `weight` = weight+$weight WHERE `username` = '$user'";

[Orionsbelter]

try that see if it works and post back please

[paul2463]

it is telling you that the query cannot run because the variable $user does not exist

 

try echo out the query instead of running it and see what I mean

 

try

$update = "UPDATE `user` SET `weight` = 'weight' + $weight WHERE `username` = '$user'";
echo $update;

 

you will find that there is no information for $user

[jakeruston]

Can't believe I messed that up guys, I spelt the variable wrong in the first place.

 

Thanks for your help.