Jhon you mentioned that one may send a batch of
queries with mysql_list? maybe I understood you wrong.
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) ;
In this case I inserted in two tables. for some
reason it doesn't allow me to have to sql statements
in $qStr. Is there a way around that.
My other option is to have one sql statement per
query .... but this would be very inefficient if I
have ti do tens of inserts in one batch ...
Cheers.
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
