Syntax Error Why?

[mme]

Hi

 

I am trying to update some values in the database however I keep getting syntax errors:

 

mysql_query("UPDATE updates SET ('file' = 'new.exe2', 'filename' = 'new.exe2', 'serverfile' = 'http://static.php.net/www.php.net/images/php.gif', 'md5' = '97f3c717da19b4697ae9884e67aab123') WHERE 'updateid' = 10;") or die(mysql_error());

 

However I keep getting this error:

 

#1064 - 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 '('file' = 'new.exe2', 'filename' = 'new.exe2', 'serverfile' = 'http://static.php' at line 1

 

What is wrong with the code?

 

Thanks,

 

mme

[Pikachu2000]

Don't quote table/field names in the query string. If you need to enclose them  for a query with MySQL, use backticks instead. `table` `field`