Why am i getting this error when i try to update my database record

[svgmx5]

I'm not sure why but i keep getting the following 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 'order=1 WHERE id=30' at line 1"

 

Normally i can figure it out, since i'm not really new to php at all, however i just don't know why this is happening i looked over everything and i can't find the reason behind this error. So i'm hoping someone else can look it over and maybe...just maybe catch what i'm not seeing.

 

require("config.php");

$x = mysql_real_escape_string($_GET['queryString']);
$y = mysql_real_escape_string($_GET['string']);

$updatePicOrder = mysql_query("UPDATE pointImages SET order='$queryString' WHERE id='$inputString'") or die(mysql_error());

[phpSensei]

I believe ORDER is a reserved word in Mysql

 

 

try this

 

$updatePicOrder = mysql_query("UPDATE pointImages SET `order`='$queryString' WHERE `id`='$inputString'") or die(mysql_error());

[svgmx5]

darn it...i keep forgetting about about those...yea you were right ORDER is reserved in mysql....what i just did was change the row name to something else and well...it worked!

 

Thanks for reminding me not to use ORDER as a row name

[phpSensei]

np, just mark the topic as solved.