[SOLVED] What does this mean?

[thefollower]

I keep getting 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 CountryID='1'' at line 1

 

Not sure what it means though.. this is my query:

 

$UpdateTreasury = "UPDATE countries SET Treasury=Treasury+$Price WHERE CountryID='$CountryID'";
$treasuryresult = mysql_query($UpdateTreasury) or die(mysql_error());

 

Can't see why its not allowing the WHERE clause..

Any one know why?

[trq]

Change your code to....

 

$UpdateTreasury = "UPDATE countries SET Treasury=Treasury+$Price WHERE CountryID='$CountryID'";
die($UpdateTreasury);
$treasuryresult = mysql_query($UpdateTreasury) or die(mysql_error());

 

and show us the output.

[thefollower]

UPDATE countries SET Treasury=Treasury+ WHERE CountryID='1'

 

Ok looks like my variable is empty then. Good spot.

[revraz]

Yes, you always need to check first to see if any variable is empty.