Jump to content

MySQL query to update multiple columns at once?


3raser

Recommended Posts

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'");

Link to comment
Share on other sites

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?

 

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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. ;)

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.