[RESOLVED] My sytax is being complained about, but I don't know why.

[schwim]

Hi there guys,

Here's my statement:

mysql_query("UPDATE addon_guild_members SET gender = '$mgender', level = '$mlevel', race = '$mrace', class = '$mclass', rank = '$mrank', last_time = NOW(), active = '1', key = '$current_key'  WHERE name = '$mname'") or die("Failed to update member in the database.<br><br>" . mysql_error());	

Which worked fine until I added this:

, key = '$current_key'

When I added that, the statement broke and I get this:

Failed to update member in the database.

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 'key = '146451373' WHERE name = 'Govannin'' at line 1

Can someone tell me what I did wrong?

[Derokorian]

You are using a Reserved Word, you either need to use a different identifier OR use backticks ( ` ) to delimit the word as an identifier.

[vivek151189]

KEY is a reserved word in mysql

[vivek151189]

KEY is a reserved word