|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #34727 nextRowset doesn't work with mysql 5 and stored procedure
Submitted: 2005-10-04 13:27 UTC Modified: 2005-10-21 10:16 UTC
Avg. Score:4.8 ± 0.4
Reproduced:3 of 3 (100.0%)
Same Version:1 (33.3%)
Same OS:3 (100.0%)
From: pointeau_sylvain at yahoo dot fr Assigned: wez (profile)
Status: Wont fix Package: PDO related
PHP Version: 5CVS-2005-10-05 (snap) OS: windows XP
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: pointeau_sylvain at yahoo dot fr
New email:
PHP Version: OS:


 [2005-10-04 13:27 UTC] pointeau_sylvain at yahoo dot fr
The second result set returned by the stored procedure is not displayed.

Reproduce code:
-- MYSQL 5
  SELECT 'second result';

-- PHP / PDO
$pdo = new PDO('mysql:host=localhost;dbname=test', '***', '***');

$stmt = $pdo->query('CALL SPG_PERSONS()');

do {
	$rowset = $stmt->fetchAll();
	foreach ($rowset as $row) {
		echo $row[0];
		echo '<br>';
while( $stmt->nextRowset() );

Expected result:
the results of both result set.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2005-10-04 14:59 UTC]
Please try using this CVS snapshot:
For Windows:

 [2005-10-05 10:43 UTC] pointeau_sylvain at yahoo dot fr
I tried with php 5.05, 5.1RC1, latest snapshot of 5 and 5.1.
I also take care to use the right PECL libraries.

It still doesn't work.

Please note that mysqli returns correctly the two result set.
 [2005-10-05 11:02 UTC]
Assigned to the maintainer.
 [2005-10-19 17:17 UTC]
You need to compile pdo_mysql yourself against 5.0 libs that have this functionality. The stock mysql libs used for win32 builds do not support this feature, which is why you cannot use it.
 [2005-10-21 10:16 UTC] pointeau_sylvain at yahoo dot fr
Please could you describe a bit how to compile the sources under windows ? I didn't find any makefile in PDO_MYSQL-1.0RC1.tgz. The compiler is MSVC or could be mingw ? Is it possible to have to link against 5.0 libs in the next release / snapshot / delivery ?

PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed Jun 19 07:01:31 2024 UTC