[PHP] PHP, MySQL & multiple commands??

[Jason Caldwell]

I'd like to be able to run a mysql_query() once while executing more than
one mysql command... for example:

while($row = mysql_fetch_array($result))
{
    $query_cmd  = "INSERT INTO tblTest1 (number) VALUES (1);";
    $query_cmd .= "INSERT INTO tblTest2 (id, val) VALUES(LAST_INSERT_ID,
'some data');";

    mysql_query($query_cmd);
}

When I run code similar to that listed above, I get a mysql error "error at
line 1." -- however, if I run the INSERTS separately -- no error.

Is there a way I can run multiple commands within one string?

Thanks
Jason



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php