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