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