Bug #18094 Updated: Multiple MySQL Statements per Query

ID: 18094 Updated by: cynic@php.net Reported By: hz11@nyu.edu -Status: Open +Status: Won't fix Bug Type: Feature/Change Request Operating System: All PHP Version: 4.2.1 New Comment: this is not going to happen. the mysql extension in php is just a thin wrapper above the mysql C lib, and that doesn't allow this. but what is far more important, this is a security measure you get for free. Previous Comments: ------------------------------------------------------------------------ [2002-07-01 14:23:59] hz11@nyu.edu 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 this bug report at http://bugs.php.net/?id=18094&edit=1