Posted by Marek Kilimajer on 10/21/54 11:10

Alex Ortiz wrote:
> Hello.
>
> Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL
> table?

no limit on php side, perhaps 2^31 if you do calculations.

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

Echo out your sql query and see if you get what you should.

[Back to original message]