ID: 45763
Updated by: [email protected]
Reported By: michael dot kofler at gmx dot com
Status: Assigned
Bug Type: MySQLi related
Operating System: linux
PHP Version: 5.3.0alpha1
-Assigned To: andrey
+Assigned To: johannes
New Comment:
Works with the procedural interface, use procedural style until fix has
been committed.
Re-assigning to Johannes. Andrey is busy with non-PHP work at the
moment. Johannes please have a look
Previous Comments:
------------------------------------------------------------------------
[2008-08-09 00:21:13] [email protected]
Assigning to primary maintainer
------------------------------------------------------------------------
[2008-08-08 13:44:27] michael dot kofler at gmx dot com
Description:
------------
mysqli::multi_query returns FALSE if more than one query is given
Reproduce code:
---------------
$mysqli = new mysqli($mysqlhost, $mysqluser, $mysqlpasswd, $mysqldb);
$sql = "SELECT 1; SELECT 2; SELECT 3";
$ok = $mysqli->multi_query($sql);
if($ok === FALSE) {
echo $mysqli->error();
}
Expected result:
----------------
non (because $ok === TRUE)
(works with mysqli + libmysql)
Actual result:
--------------
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; SELECT 3' at line 1
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=45763&edit=1
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.