|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits              [2007-04-08 15:26 UTC] iliaa@php.net
 | |||||||||||||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 04:00:01 2025 UTC | 
Description: ------------ Description: ------------ Using PDO DBLIB driver to connect to MySQL server each SELECT query I've tried this far returns a valid resultset but PDOStatement::rowCount() always returns 0. When i use php 5.1.6 all works fine. Reproduce code: --------------- <?php $db = new PDO("mysql:host=xxx;dbname=xxx", "xxx", "xxx", array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true)); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $r = $db->query("SELECT * FROM xxx"); echo "<pre>"; echo "rowCount = ".$r->rowCount(); echo "</pre>"; ?> Expected result: ---------------- rowCount = 540554 Actual result: -------------- rowCount = 0