ID:               32433
 Updated by:       [EMAIL PROTECTED]
 Reported By:      alexzhen at hotmail dot com
-Status:           Open
+Status:           Bogus
 Bug Type:         MySQLi related
 Operating System: WinXP (Professional) with SP2
 PHP Version:      5.0.3
 New Comment:

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. 

Thank you for your interest in PHP.




Previous Comments:
------------------------------------------------------------------------

[2005-03-23 19:23:24] alexzhen at hotmail dot com

Description:
------------
using php5.0.3 and mysql 4.1.9

i think i've similar bug with <a
href="http://bugs.php.net/bug.php?id=31668";>http://bugs.php.net/bug.php?id=31668</a>

anyway, if you remove line 8 and 9. it work perfectly fine.
or you can add these following codes between the line 8 and 9.

$mysqli=new mysqli("localhost", "root", "xxx", "xxx");
$mysqli->query("");
$mysqli->close();

thanks

Reproduce code:
---------------
1:              $mysqli = new mysqli("localhost", "root", "xxxxxxxxxxxxxx",
"xxxxxxxxx");
2:              if ($mysqli->multi_query("select 1 as Total")) {                
3:                      if (!$result = $mysqli->store_result()) die("first 
section query
error");
4:                      echo "Total: ".$result->fetch_object()->Total; //should 
output
Total: 1.
5:                      echo "<br><br>";
6:                      $result->free();
7:              }else echo $mysqli->error;
8:              $mysqli->close();
9:              $mysqli = new mysqli("localhost", "root", "xxxxxxxxxxxxx",
"xxxxxxxxxxxxx");
10:     if ($mysqli->multi_query("select 1 as Total;select 2 as Needle"))
{
11:             if (!$result = $mysqli->store_result()) die("second section 
query
error");
12:             echo "Total: ".$result->fetch_object()->Total;
13:             $result->free();
14:             echo "<br><br>";
15:             $mysqli->next_result();
16:             if (!$result = $mysqli->store_result()) die("second section 
query
error");
17:             echo "Needle: ".$result->fetch_object()->Needle;
18:             $result->free();
19:     }else echo $mysqli->error;      
20:     $mysqli->close();

Expected result:
----------------
Total: 1

Total: 1


Needle: 2

Actual result:
--------------
Total: 1

You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ';select 2
as Needle' at line 1


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=32433&edit=1

Reply via email to