I am translating an MS-SQL application into mysql/php. I need to be able to send a batch of queries all at once. For example: $qStr = " Insert into A(name, address) values('$name', '$address') ; Insert into B(personID, department ...)values (@@identity, '$department');" ;
$result= mysql_query($qStr, $link) ;
No, you can only run one query at a time.
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php