MySql Update problem?

[iNod]

Hello,

        $getorder = "SELECT * FROM form_fields WHERE fid='".$fid."'";
        $go = $db->fetch($db->query($getorder));
        $neworder = $go['order']-1;

		$update_query = "UPDATE form_fields SET order='".$neworder."' WHERE fid='".$fid."'";
		$data = $db->query($update_query);
		print '<p>Field has been successfully moved.</p><br />';

That is the code and I get

UPDATE form_fields SET order='9' WHERE fid='270'
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='9' WHERE fid='270'' at line 1

What could be the problem?

Thanks,

 

[axilant]

$update_query = "UPDATE form_fields SET order = '$neworder' WHERE fid = '$fid'";

 

[iNod]

Nice try Axilant but it doesn't work

I have tried everything..

 

[Peter]

order is a reserved word in mysql

http://dev.mysql.com/doc/mysql/en/reserved-words.html

this may be the cause of your problem, try changing the name of the field.