ID: 30081 Updated by: [EMAIL PROTECTED] Reported By: nxcoder at gmail dot com -Status: Open +Status: Bogus Bug Type: MySQLi related Operating System: win2000 PHP Version: 5.0.1 New Comment:
tested against latest cvs and 5.0.2. Output: Array ( [0] => 1 [@@autocommit] => 1 ) Array ( [0] => [EMAIL PROTECTED] [current_user()] => [EMAIL PROTECTED] ) Also your actual result is wrong/incomplete: please specify the complete error message next time. Previous Comments: ------------------------------------------------------------------------ [2004-09-14 10:19:11] nxcoder at gmail dot com Description: ------------ use $str ="select @@autocommit;"; $str .= "select current_user();"; reportting errors! ------------------------- use $str ="select @@autocommit;"; or $str = "select current_user();"; result is right; Reproduce code: --------------- <?php echo "<pre>"; $mysqli = new mysqli("localhost", "root", "", "EPS"); if(mysqli_connect_errno()) die(mysqli_connect_error()); $str ="select @@autocommit;"; $str .= "select current_user();"; $mysqli->multi_query($str) or die($mysqli->error); do{ if($result=$mysqli->store_result()) while($row = $result->fetch_array()) print_r($row); } while($mysqli->next_result()); ?> Expected result: ---------------- print out two array Actual result: -------------- Unknown command ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30081&edit=1