MySQL - PHP - limits...
| From: | Alex Ortiz | Date: | Wed, 09 Mar 2005 01:29:58 +0000 |
| Subject: | MySQL - PHP - limits... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-210275@lists.php.net to get a copy of this message | ||
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