Select queries limited?

Hello,

I notice that when i have a table that has more than maybe approx 450 rows they just dont show up. They dont show up in phpmyadmin or the custom php script i have written to display all records. I think its some system variable thats limiting the size (maybe the Max allowed packet, not sure however). This query is NOT a join query, its a simple "select * from table". However the entry is inserted in the dbase for sure, cause if you use a where clause to retrive the newly inserted record, it does appear.

Anybody knows what the issue maybe?

thanks'
Neville

I suppose there may be some kind of time restriction involving the PHP parser and/or MySQL server in play here. I have a table with a little over 500 rows containing several fields that works OK. Are you using a single query or queries in a loop?

I got the solution. The problem was that there was lots of data being exchanged from that one page to and fro to the mysql database. Optimized the queries on that page and it was working fine.

thanks