Edit report at http://bugs.php.net/bug.php?id=52090&edit=1
ID: 52090
Updated by: kalle@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