About mysql update clause

[weekenthe9]

How can you update multiple columns together? Does this work?

 

$query = "UPDATE ".$table_name." SET (`Field1`, `Field2`, `Field3`)

VALUES ('$Value1', '$Value2', '$Value3')";

[Maq]

What makes you think that it won't work, did you try it?

[weekenthe9]

This is the query I was trying:

 

UPDATE comments_test SET (`user`, `comment_Link`, `Project_Key`)

VALUES ('A', 'B', '12') WHERE `Key`='6'

 

But it gives an error message saying:

 

ERROR 1064: You have an error in your SQL syntax.

[Maq]

Most people use UPDATE like this:

 

$sql = "UPDATE comments_test SET user = 'A', comment_Link = 'B', Project_Key = 12 WHERE Key=6;"
echo "Your query: " . $sql;
mysql_query($sql) or die(mysql_error());

 

Although I think you can use the syntax you were trying.