Re: Query Batch
| From: | John W. Holmes | Date: | Wed, 19 Nov 2003 02:43:41 +0000 |
| Subject: | Re: Query Batch | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-170231@lists.php.net to get a copy of this message | ||
b b wrote:
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