Bug #18094: Multiple MySQL Statements per Query

From: hz11@nyu.edu Operating system: All PHP version: 4.2.1 PHP Bug Type: Feature/Change Request Bug description: Multiple MySQL Statements per Query I think a valuable addition to the MySQL functionality would be a way to run multiple statements per mysql_query() call. For instance: mysql_query('CREATE DATABASE mynewdb; CREATE TABLE newtable(id TINYINT NOT NULL);', $mysql_link); Currently, I would get a SQL syntax error at the first semicolon. How would results be handled, from SELECTs, INSERTs, etc? Maybe an array of results/IDs could be returned, or a result/ID set that is itself an array. Thank you, Hans -- Edit bug report at http://bugs.php.net/?id=18094&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18094&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18094&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18094&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18094&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18094&r=support Expected behavior: http://bugs.php.net/fix.php?id=18094&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18094&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18094&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18094&r=globals