[bono56]

why i cant pass 2 query separated by a ";" to a mysql_query() function?

$sql_query = "UPDATE table1 SET serial_num='AB101' WHERE id=101;UPDATE table1 SET serial_num='AB102' WHERE id=102;";
$db_result = mysql_query($sql_query);

in phpMyAdmin i paste this kind of queris & it works, how phpMyAdmin handle such a query? separate & run them separately or ...?

[aschk]

I expect that phpMyAdmin seperates them out into two seperate queries. Consult the phpMyAdmin documentation to verify this.