Sending out more then one email takes forever...need easier way please HELP!

iBuddy

Okay I made myself a basic newsletter. For the admin controls I basically just did the following code:

     


if (isset($submit_newsletter)) {
$result = mysql_query("Select * from newsletter");
while ($show = mysql_fetch_assoc($result)) { 

mail($show[email], $subject, $message, "From: [email]Newsletter@gunitworld.com[/email]");


}
echo "sent";
}

Now this works but I have over 400 emails in my sql database. This takes forever to send. However, in forums they send instantly. What can I do different to make this execute faster?

yousaf931

iF u send more that 35 email instantly the mail server will consider is at a spam ( most of servers use this technique to prevent spamming).

So it would be better to use limit (sql) function and time fuction to set the interval and limit of email addresses to pervent abuse of mail server.

Cheers,
yousaf FAYYAZ.

iBuddy

ohhhhh really? thanks

im so clueless on what to do for the limit and time functions tho...can you help?

yousaf931

see the manuals there they explain better than i can write in here.

if u r familar with javascript use settimeinterval() function to shot a specific function after the specific time.

About limit .. i can give u clue .. have u use phpmyadmin .. When u fetch the results it will show 10 by default . And u can also see the example limit query generated by phpmyadmin.

Cheers,
yousaf FAYYAZ.

iBuddy

SELECT * 
FROM `articles`  LIMIT 0 , 30

thats the limit....but damn i would have to keep doing this like say 300 times because I would have to change the LIMIT.......do u know how the forums send bulk email?

yousaf931

Create a function use variable in a loop to change the limit.

whatever.

I dint ever use bulk emailing. Buz it is againts the ethics. You are increasing internet trafic for your own good reason thats not fair.

Cheers,
yousaf FAYYAZ.

iBuddy

Originally posted by yousaf931
Create a function use variable in a loop to change the limit.

whatever.

I dint ever use bulk emailing. Buz it is againts the ethics. You are increasing internet trafic for your own good reason thats not fair.

Cheers,
yousaf FAYYAZ.

what u mean its not fair lol its a newsletter...

yousaf931

lol i though u r doing it for spaming.

Try google some one have given the code for it that suits ur needs.

Cheers,
yousaf FAYYAZ.

iBuddy

spamming what are you talking about?!?!

its a newsletter that members of my site sign up for! and confirm their email....how the hell is that spamming?

yousaf931

yOU MIGHT BE HOW are going to give the grantue.

lolz .. u got hyper. i love to see ppl bitng their nails.

Cheers,
yousaf FAYYAZ.

iBuddy

Someone said that I need to connect to the smtp....anyone know how to do that cuz im still frustrated on trying to get this setup!

Weedpacket

Have a search around for a pre-existing SMTP class (www.phpguru.org springs to mind). It will be a lot faster than sending one mail at a time, because mail() has to create a connection to your mail server, send one mail, close the connection, create a new connection to your mail server, send one mail, close the connection.... That will be where your real delay is (why would your server slow you down as spam prevention? If you were sending hundreds of emails through someone else's mail server, they might throttle that email traffic). Talking SMTP directly means all the work can be done in one connection.

yousaf931: You getting tired? Your typing is getting worse and worse with every post.