From: alexander dot over at koeln dot de Operating system: Suse 9.3 PHP version: 5.1.4 PHP Bug Type: MySQLi related Bug description: MySQLi multi_query functionality results in error
Description: ------------ Sorry for that english :D When trying to use the multi_query functions from mysqli adapter, it always fails with an syntax error if more than one sql statement is given to the function/object. Reproduce code: --------------- $mysqli = new mysqli('localhost', 'root', '', 'test'); $query = "SELECT CURRENT_USER();"; $query .= "SELECT CURRENT_USER();"; if ($mysqli->multi_query($query)) { do { if ($result = $mysqli->store_result()) { while ($row = $result->fetch_row()) { printf("%s\n", $row[0]); } $result->close(); } } while ($mysqli->next_result()); } else { echo $mysqli->error; } $mysqli->close(); Expected result: ---------------- [EMAIL PROTECTED] [EMAIL PROTECTED] Actual result: -------------- Fehler in der Syntax bei ';SELECT CURRENT_USER()' in Zeile 1. (German Locale) -- Edit bug report at http://bugs.php.net/?id=37567&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37567&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=37567&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37567&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=37567&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=37567&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=37567&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=37567&r=needscript Try newer version: http://bugs.php.net/fix.php?id=37567&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=37567&r=support Expected behavior: http://bugs.php.net/fix.php?id=37567&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=37567&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=37567&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=37567&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37567&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=37567&r=dst IIS Stability: http://bugs.php.net/fix.php?id=37567&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=37567&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=37567&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=37567&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=37567&r=mysqlcfg