UPDATE not working

[TGWSE_GY]

Hi guys

 

I am getting and error message of: "

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='22'' at line 1"

 

with the code

<?php
$array=$_POST['imgid'];
include('config.site.php');
foreach($array as $key=>$val){
$q = "UPDATE `galleries` SET order='$val' WHERE id='$key'";
mysql_query($q) or die(mysql_error());
}

?>

 

I am pretty sure that my update statement is correct, but it just is not working. Any ideas.

 

Thanks

[aebstract]

Not sure if it will make a difference, but I would try this:

 

<?php
$array=$_POST['imgid'];
include('config.site.php');
foreach($array as $key=>$val){
   $q = "UPDATE galleries SET order='$val' WHERE id='$key'";
   mysql_query($q) or die(mysql_error());
}

?>

[TGWSE_GY]

aebstract: thanks but that didnt work. Still getting the same error.

 

Thanks Though 

[TGWSE_GY]

OKAY So I am completely lost. I know my syntax is correct and still not working. The record exists and should update so why the error??? Any Ideas???

 

Here is the code again

<?php
$array=$_POST['imgid'];
include('config.site.php');
foreach($array as $key=>$val){
   $q = "UPDATE `galleries` SET order='$val' WHERE id='$key'";
   mysql_query($q) or die(mysql_error());
}

?>

 

Thanks Guys  :confused: :confused:

[TGWSE_GY]

So I guess I am alone in figuring this out as noone has a suggestion on how to fix this error.

 

Thanks

[TGWSE_GY]

OK Well Congrats to me I figured it out, seems that since "ORDER" is a reserved word, we are unable to use the name order for a field. If I am incorrect someone feel free to correct me.