simultaneous updating of rows in a databse

[backups2007]

How do I simultaneously update rows of data in a database?
Should I Update it one by one? Or is there any other way to do it?

$query = mysql_query("UPDATE tblProducts SET prod_code='$prod_code1'");
if($query)
{
$query2 = mysql_query("UPDATE tblProducts SET prod_code='$prod_code2'");
 
if($query2)
{
    echo "update success!";
}
}
 

[t0m66]

Well, that code there will just set it to the last value because there is no WHERE condition. (First, it will set it to query 1's value, but then it will all be set to query 2's value). To run multiple queries in a MySQL call, you can seperate them with semicolons, but I wouldn't know why you'd want to do that.

[gregerly]

To run multiple queries in a MySQL call, you can seperate them with semicolons

I'm actually pretty sure mysql_query() can only run one query at a time. Seperating with semicolons won't work.

From the www.php.net website:

mysql_query() sends an unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier.

Here is the link: php.net - info on mysql_query()

[backups2007]

can't i do something like that of how inserting data is done?

$query = mysql_query("INSERT INTO tblProducts (product_id, description)VALUES ('prod_id1','desc1'),('prod_id2','desc2')");