Updating multiple columns

[bluns]

Hi all, I am trying to update multiple rows via php, but upon running mysql_error() i get 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...."

 
$query = "update cardata set (xxx, yyy, zzz)		
values    ('xxx', 'yyy', 'zzz') where $id=id"; 
mysql_query($query) or die(mysql_error());
 

I am quite new to mysql and i cannot figure what is wrong?

[cullouch]

Originally posted by bluns
Hi all, I am trying to update multiple rows via php, but upon running mysql_error() i get 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...."

 
$query = "update cardata set (xxx, yyy, zzz)		
values    ('xxx', 'yyy', 'zzz') where $id=id"; 
mysql_query($query) or die(mysql_error());
 

I am quite new to mysql and i cannot figure what is wrong? [/B]

the update syntax is update table set xxx=xxx, yyy=yyy
where id=$id