MySQL Troubles (SET multiple column values)

[darknuke]

mysql_query("UPDATE mytable SET columnname1='$value1' WHERE id='$user[id]'");
mysql_query("UPDATE mytable SET columnname2='$value2' WHERE id='$user[id]'");
mysql_query("UPDATE mytable SET columnname3='$value3' WHERE id='$user[id]'");

I need to set multiple values in a single row, and was wondering how I can accomplish this in a single query. (I've tried the AND operator with no success)

[ScubaKing22]

One word: commas.

mysql_query("UPDATE mytable SET columnname1='$value1',columnname2='$value2',columnname3='$value3' WHERE id='$user[id]'");

Hope this helps 😉

[darknuke]

🙂 Yes it does, thanks.