ID: 40822 Updated by: [EMAIL PROTECTED] Reported By: vitaliy dot okulov at gmail dot com -Status: Open +Status: Assigned Bug Type: PDO related Operating System: Gentoo Linux 2006.1 PHP Version: 5.2.1 -Assigned To: +Assigned To: wez
Previous Comments: ------------------------------------------------------------------------ [2007-03-15 15:34:37] vitaliy dot okulov at gmail dot com 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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40822&edit=1