ID: 40167 Updated by: [EMAIL PROTECTED] Reported By: burg1 at gmx dot net -Status: Open +Status: Bogus Bug Type: Documentation problem PHP Version: Irrelevant New Comment:
ext/mysql is meant for mysql3 ext/mysqli is meant for mysql4.1+ You are looking for http://php.net/mysqli_multi_query Previous Comments: ------------------------------------------------------------------------ [2007-01-19 15:14:27] burg1 at gmx dot net My (naive) assumption was that you can take any valid MySQL-command, wrap mysql_query() around it, and there you go ;-) All I'm asking about is to include a short note to prevent others from trying back and forth, thereby wasting an hour, as I just was...... MySQL: I have MySQL 5.0, and although the command worked perfectly fine when entered directly into phpMyAdmins's SQL-window, it didn't work through mysql_query. ------------------------------------------------------------------------ [2007-01-19 15:07:34] [EMAIL PROTECTED] Where does it imply that you can run multiple queries at once in our docs? And FYI: AFAIK only MySQL 3.x disliked it, but MySQL 4.1+ allows it. ------------------------------------------------------------------------ [2007-01-19 14:28:57] burg1 at gmx dot net Description: ------------ As far as I can see, the following command is not possible: mysql_query("INSERT INTO (name) VALUES ('Lucy'); INSERT INTO (ids) VALUES (1);"); My suggestion: Please include a notice to the mysql_query-function that only one MySQL-command can be sent at a time. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40167&edit=1
