Edit report at http://bugs.php.net/bug.php?id=52090&edit=1
ID: 52090 Updated by: ka...@php.net Reported by: gsx1022 at gmail dot com Summary: mysql_fetch_assoc returns infinite number of records Status: Open Type: Bug Package: MySQL related Operating System: Linux x86 PHP Version: 5.3.2 New Comment: Do you use mysqlnd with ext/mysql or libmysql, in either case does it solve switching the lib? Is mysqli affected by this issue too on your machine? Previous Comments: ------------------------------------------------------------------------ [2010-06-15 21:35:55] gsx1022 at gmail dot com Description: ------------ A MySQL query that should return 5 records returns an infinite number of records. It returns the 5 five records correctly, but then it returns them again, and again, and again... Other SELECT statements are fine, this is the only problematic one. Also, this query works from the MySQL console just fine. At first I thought it is an issue with Zend Framework but it turned out it is probably not. See this url for (much) more info (also detailed information to reproduce): http://framework.zend.com/issues/browse/ZF-9982 Test script: --------------- $c = mysql_connect('host', 'user', 'pass'); mysql_select_db('db', $c); $raw = mysql_query('SELECT `name`, `level`, `parent` FROM `allresources_view` ORDER BY `level` ASC'); while ($r = mysql_fetch_assoc($raw)) { var_dump($r); echo '<br /><br />'; } mysql_close($c); Expected result: ---------------- 5 records should have been returned from the database. Actual result: -------------- An infinite number of records are returned from the database. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=52090&edit=1
