limit to number of loops through "while"

Anon

Can anyone tell me if there is a max. for the number of time you can loop through a "while" loop?

Seems to be that after 70 times through, it bogs down the browser and memory of the computer. I've experimented and found that anything over 70 records doesn't work right.

while(mysql_fetch_array($result)){
//seems to only work 70 times maximum
}

help please...

Anon

It would depend on what you're doing within the while loop. If you're just printing something, then the only limit you have to worry about is the execution time limit of the script (default is 30 seconds). If you're doing something that is memory intensive, then it could slow down, but there shouldn't be any kind of limit...

Maybe it's a browser thing? Maybe the browser doesn't like tables with more than 70 rows?? you never know...

---John Holmes...

Anon

Hi,

Either way, depending on the available memory in the visitor's browser and the execution time of your script is not A Good Thing. I would suggest you use the LIMIT-directive with your queries limiting the number of results displayed on each page.

Johan

Anon

It seems weird that it would stop at 70, though. Maybe it's something else in your code, what are you doing within and around this loop?

I've returned 1000 rows from a database and printed them to a table and never had any trouble. it worked within the 30 seconds, too...

---JH

Anon

Reason it takes so long is that each record displays two drop down boxes and the first box only shows 3 options while the second shows anywhere from 1 to over 300.

So in incrementing the number in the second drop down box, it takes too damn long. I am thinking I'll have to limit the records to 30 per page. I'll have to work on that but i'm thinking I'd use the mysql limit command?

Thanks for the help.