Re: Multiple MySQL Queries

Not that I know of. Try taking a look in the php manual (http://www.php.net) for the MySQL Section. If you can find a method there, then use it. Otherwise I believe you are better off doing each query one by one. On another note, if you did do them all at the same time and something went wrong it makes de-bugging harder... Stephen ----- Original Message ----- From: "Uttam" <uttam@lml.co.in> To: <php-windows@lists.php.net> Sent: Saturday, February 01, 2003 10:16 AM Subject: [PHP-WIN] Multiple MySQL Queries > in MySQL client i can run multiple queries in a single statement like: > > "CREATE TEMPORARY TABLE x (a CHAR(6), b FLOAT(12,4)); INSERT INTO x SELECT > a, sum(*blah*)..FROM y ; SELECT * FROM x INNER JOIN z ....;" > > but in PHP ";" is not allowed in function mysql_query(). > > Is there some workaround for running the above query in PHP in a SINGLE > mysql_query() call? > > > thanx! > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >