MySQL - PHP - limits...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello.

Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL 
table?

I´m browsing a table with PHP from MySQL, and something is wrong, if the 
table has more than 5047 records, the browse appears blank. Additionaly, if 
make the browse in a child window (target="_blank"), the limit becomes 
lower: 437 records.

My SQL query is:

SELECT * FROM my_table ORDER BY my_order_index

The way I "solve" the problem is adding LIMIT 5047 to query (or 437), just 
for testing. This works fine.

My table has 11300 records, with 9 small fields (average 10 bytes each).

I run SuSE Linux 8.2, Apache2.0, PHP 4.3.3, and MySQL 4.0.15.

Any idea?.

Thanks in advance,
Alex Ortiz 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux