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

ID: 11785
Updated by: derick
Reported By: trozdzyn <email protected>
Old-Status: Open
Status: Closed
Bug Type: MySQL related
Operating system:
PHP Version: 4.0.6
Assigned To:
Comments:

Try putting this line after the mysql_unbuffered_query line.
You'll probably see the error that MySQL returns. This is most likely a bug in PHP.

Derick

Previous Comments:
---------------------------------------------------------------------------

[2001-06-28 13:40:17] trozdzyn <email protected>

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!!!

---------------------------------------------------------------------------

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11785&edit=2 

-- 
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>