[SOLVED] mySQL syntax error

[eludlow]

OK this is driving me totally round the bend.

 

My query is this:

 

$editQuery = mysql_query("UPDATE `membership` SET title='$title', initials='$initials', surname='$surname', address1='$address1', address2='$address2', address3='$address3', address4='$address4', county='$county', postcode='$postcode', left='$left', type='$type', email='$email', phone='$phone'  WHERE id='$toEditId'");

 

Which returns 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 'left='', type='Annual', email='', phone='' WHERE id='223'' at line 1

 

However, if I remove the " left='$left' " part of the query it all works fine.  The column "left" is fine, and is beign used by other queries fine...the variable $left is also fine, can be echoed no worries.  (FWIW $left = a four digit year, which is being put into a text field...so no problems there I don't think?).

 

If I use this....

 

$editQuery = mysql_query("UPDATE `membership` SET title='$title', initials='$initials', surname='$surname', address1='$address1', address2='$address2', address3='$address3', address4='$address4', county='$county', postcode='$postcode', type='$type', email='$email', phone='$phone'  WHERE id='$toEditId'");
if (!$editQuery) {
	$dbError = "An error has occured. " .  mysql_error();
	die("$dbError");
}
#die($left);

 

which has the troublesome part removed, it executs fine, and then prints the $left variable fine and then dies..as I want.

 

So what's its problem??!!

 

Any help appreciated.

 

Thanks,

Ed Ludlow

[Wildbug]

Can you print the query string as generated (save to a var and print -- one that causes an error) and post a "DESCRIBE membership"?

[eludlow]

Done it!  Turns out left is a mySQL function...so....

 

`left` = '$left'

 

does the trick

 

Thanks!

[fenway]

Done it!  Turns out left is a mySQL function...so....

 

`left` = '$left'

 

does the trick

 

Thanks!

Not a function, a reserved keyword... as in "LEFT JOIN".