[SOLVED] update query

[adam291086]

Whats wrong with this update code, i have been coding for a while and my head is hurting and this is probably simple. The variable are definitly being set

 

echo $left;
echo $top;
echo $height;
echo $width;
$conn;
mysql_query("UPDATE Admin_Page_Objects SET Height ='$height', Width ='$width', Top = '$top, Left = '$left' WHERE ID ='1'") or die (mysql_error());

[br0ken]

echo $left;
echo $top;
echo $height;
echo $width;
$conn;
mysql_query("UPDATE Admin_Page_Objects SET Height ='$height', Width ='$width', Top = '$top', Left = '$left' WHERE ID ='1'") or die (mysql_error());

 

You had not closed your speech mark after $top.

 

You should've been able to find this based on the error message.

[adam291086]

still 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 'Left = '70px' WHERE ID ='1'' at line 1

[br0ken]

This is a new error caused by the fact that you've used a MySQL reserved word as a column name which is not allowed. Left is a reserved word similar to SELECT or INSERT and therefore causes a syntax error used the way you're using it. Rename this field and eveything should work fine (unless you have more syntax errors in which case you should report back here).

 

If this solves the problem please click 'Topic Solved' at the bottom of this thread 

 

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