updating multipule rows from one array

[mhikey]

I'm trying to update multipule rows (same col).
While I understand that I need to use a loop to run the command over again I seem to get lost when it comes to adding mysql results to the mix. I'm still newbie and I might be overlooking something very simple so please be kind. I'm eager to learn.

There are two rows with BuyID of '2' and they both need Item status changed to '2'

mysql_query(SELECT ItemID, ItemStatus FROM Items where BuyID='2');
$result = mysql_query($sql_query) or die ("Query failed");
$row = mysql_fetch_array($result);

UPDATE Items set ItemStatus='2' WHERE ItemID='$row[ItemID]';

[LordShryku]

$sql = "SELECT ItemID, 
               ItemStatus 
        FROM   Items 
        WHERE  BuyID='2'";

$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
   mysql_query("UPDATE Items 
                SET    ItemStatus='2' 
                WHERE  ItemID='".$row['ItemID']."'");
}

[Drakla]

Couldn't this all be done with just the one query being as it's the same table in both?

mysq_query("UPDATE Items SET ItemStatus='2' WHERE BuyID='2'");

Check I'm not being an idiot, though.

[LordShryku]

Yeah, looks like it could, but maybe this is just an example?