#40246 [Opn->Fbk]: nextRowset() doesn't work
| From: | tony2001@php.net | Date: | Fri, 26 Jan 2007 10:02:21 +0000 |
| Subject: | #40246 [Opn->Fbk]: nextRowset() doesn't work | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-108084@lists.php.net to get a copy of this message | ||
ID: 40246
Updated by: tony2001@php.net
Reported By: bergheim at stud dot ntnu dot no
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: Linux Debian
PHP Version: 5.2.0
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.2-win32-latest.zip
Previous Comments:
------------------------------------------------------------------------
[2007-01-26 09:14:14] bergheim at stud dot ntnu dot no
Description:
------------
Using:
* PHP 5.2.0-8
* PDO MySQL 5.0.32
* MySQL 5.0.32
Only one rowset show up using nextRowset() in PDO.
Reproduce code:
---------------
[SQL]
DELIMITER $$
DROP PROCEDURE IF EXISTS
multiple_rowsets $$
CREATE PROCEDURE testing ()
BEGIN
SELECT "apple" AS fruit;
SELECT "banana" AS fruit;
END $$
DELIMITER ;
[/SQL]
[PHP]
Use code from
http://www.php.net/manual/en/function.pdostatement-nextrowset.php
[/PHP]
Expected result:
----------------
The code show two generating tho resultsets at the page. See code in
manual.
Actual result:
--------------
Only the first rowset show up.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=40246&edit=1