Hi,
Is it possible to update multiple records, using only 1 sql query?
I'd like to do something like....
$sql="update table set value1='1' where id='1'
update table set value2='2' where id='2'
update table set value3='3' where id='3'";
$result = mysql_query($sql);
Rather than
$sql1="update table set value1='1' where id='1'"'
$result1 = mysql_query($sql1);
$sql2="update table set value2='2' where id='2'"'
$result2 = mysql_query($sql2);
$sql3="update table set value3='3' where id='3'"'
$result3 = mysql_query($sql3);
Is this possible?
Regards
Ben
