Bug #11785: mysql_unbuffered_query and mysql_query failure.
| From: | trozdzyn at anronet dot pl | Date: | Thu, 28 Jun 2001 17:40:17 +0000 |
| Subject: | Bug #11785: mysql_unbuffered_query and mysql_query failure. | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-58364@lists.php.net to get a copy of this message | ||
From: trozdzyn@anronet.pl
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