[PHP-DEV] Bug #11785: mysql_unbuffered_query and mysql_query failure. From: trozdzyn <email protected>
Date: 06/28/01

From: trozdzyn <email protected>
Operating system: Linux redhat 7.0
PHP version: 4.0.6
PHP Bug Type: MySQL related
Bug description: mysql_unbuffered_query and mysql_query failure.

I have mysql table with over 60000 records inside.

code:
$sql = "SELECT * FROM database.table ORDER BY field";
$result = mysql_unbuffered_query($sql) or die("Error!");
does not work at all but displays "Error!"

code:
$sql = "SELECT * FROM database.table ORDER BY field limit 1,1000";
$result = mysql_unbuffered_query($sql) or die("Error!");
works fine.

code:
$sql = "SELECT * FROM database.table";
$result = mysql_unbuffered_query($sql) or die("Error!");
works fine.

Moreover , there is exactly the same problem with mysql_query() function...

My system is:
PHP: 4.0.6
MySQL: 3.23.22
Linux Kernel: 2.2.17-14

Help!!! 

-- 
Edit Bug report at: http://bugs.php.net/?id=11785&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>