Jump to content

Update one column Question


kigogu

Recommended Posts

Hi,

 

I was wondering if there was a way to do a single update for one column but for multiple rows? To clarify, I have an array that holds the id of multiple rows and I want to update these rows with a single value in one go instead of having to loop through my array and then doing an update.

 

Right now I have:

foreach ($found as &$value)
{
mysql_query("UPDATE account SET found = 1 WHERE id = '" . $value . "'");
}

 

is there any way to get rid of the foreach loop and just have mysql_query("UPDATE ....")? or at least a faster and more efficient way of doing this?

Link to comment
https://forums.phpfreaks.com/topic/259898-update-one-column-question/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.