ID: 34727 Updated by: [EMAIL PROTECTED] Reported By: pointeau_sylvain at yahoo dot fr -Status: Open +Status: Feedback Bug Type: PDO related Operating System: windows XP PHP Version: 5.1.0RC1 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2005-10-04 13:27:31] pointeau_sylvain at yahoo dot fr Description: ------------ The second result set returned by the stored procedure is not displayed. Reproduce code: --------------- -- MYSQL 5 CREATE PROCEDURE `SPG_PERSONS`() BEGIN SELECT * FROM TEST_PERSON; SELECT 'second result'; END -- 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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34727&edit=1
