PHP5 - PHP while loop issue

I have PHP script contains a long loop to list about 60,000 email addresses from mysql, but after 30,000, my php script stops working and brakes, and sometimes all php script is written in white page (my page has imaged background), I increased PHP memory limit to unlimited and set max_execution_time to 0, but no help.

My server has 2GB RAM.

What's problem?

Maybe try breaking it up by limiting 0-10000 uthen do 10001-20000 etc using limit. I'm not sure but maybe beyond the maximum size of an array to load the results of the query in. Could be wrong and I'm sure a more experienced member will correct me.

The first step in fixing a problem is always to figure out what the problem is. It sounds like you have error reporting turned off. Look in the FAQ for several methods of turning it on. Once you've done that, you should get a useful error message when you run the script that will tell you what is going wrong.

It's possible that the script is running out of memory.

error reporting is on, and it shows no errors for today.

Anyway, I changed my while loop to save email addresses in one text file using fwrite, and prints nothing in my php page, and this one is working for me, I got all emails in text file.

Um, why are you trying to print 60,000 raw email addresses, anyway?

Because I wanted to copy then paste them in my mailing list, mailing list is in a separate server, but I noticed that it accepts text file containing email addresses.

LOL! That was my first question too! I was thinking, "definitely not going to help a spammer"

Sounds like your server is timing out. Breaking it up is the easiest way. 60,000 emails don't take up 2gb of ram (although I hope this server isn't used for anything major with only 2gb of ram).

Breaking it up into 10,000s would help a lot, but (12) 5,000 runs would be HELLA faster. From my experience, it seems that after about 6-7k things start getting jankie.

Split it up, recompile on the receiving end and all will go well. (oh yeah, and buy some more ram, it's cheap now. )

ill keep this guy in mind next time i get an email from the prince of south africa :P

LOL, I'm not a spammer, I have my own forum with about 60,000 subscribers, and I want to send them new news, and also there is a link to unsubscribe.