MySQL query to update multiple columns at once?

[3raser]

I made a small editing system for my news page, and I need to update three columns within my table "announcements" in the database. I tried a method of updating all of them with one MySQL query instead of using three as it just isn't neat. I've searched several methods via google and I've tried all of them, but just can't seem to get it to work. Is this MySQL query correct?

 

mysql_query("UPDATE announcements SET title = {$title} WHERE id = '$id', content = {$content} WHERE id = '$id', lastmodified = ". date('M-d-Y') ." WHERE id = '$id'");

[Psycho]

So, you want to update three fields FOR THE SAME RECORD? You are making it too hard.

 

$query = "UPDATE announcements
          SET title = {$title}, content = {$content}, lastmodified = NOW()
          WHERE id = '{$id}'";
mysql_query($query);

[3raser]

So, you want to update three fields FOR THE SAME RECORD? You are making it too hard.

 

$query = "UPDATE announcements
          SET title = {$title}, content = {$content}, lastmodified = NOW()
          WHERE id = '{$id}'";
mysql_query($query);

 

Thank you, this is greatly appreciated. And may I ask you why you put now()?

 

Also, how does separating the query into a variable make it more efficient?

 

 

[trq]

Thank you, this is greatly appreciated. And may I ask you why you put now()?

 

It does the same thing as calling php's date() as you did but uses a mysql function instead.

 

Also, how does separating the query into a variable make it more efficient?

 

It doesn't. But it is a good habit to get into as it can come in handy when debugging.

[3raser]

Thank you, this is greatly appreciated. And may I ask you why you put now()?

 

It does the same thing as calling php's date() as you did but uses a mysql function instead.

 

Also, how does separating the query into a variable make it more efficient?

 

It doesn't. But it is a good habit to get into as it can come in handy when debugging.

 

Thank you for the information.