My hosting company has screwed up the usefulness of my newsletter
script by putting a limit of 200 emails per hour on their server. I
only have a couple of sites with newsletters that have more
subscribers than that (approx. 400 and 1500 subscribers) - but when
the send their newsletters many of their subscribers are no longer
getting their email.
I've spoken to the hosting company - but they are not interested in
helping - other than saying I need to re-write my Perl script to send
the emails out in batches.
Can anyone tell me how I do that - or point me in the right direction?
Currently I select the emails from a MySQL database and then send the
emails. Here is the relevant bit from my script:
# Connect to the database.
my $dbh = DBI ->connect("$dbaseconnectstring", "$dbaseuser",
"$password", {RaiseError => 1 })
or die "connecting : $DBI:: errstr\n";
my $sth = $dbh->prepare("select members.email, members.newsastext from
members where members.receivemail = 'y' and members.accesslevel =9" );
$sth->execute;
while (my ($mailaddress , $newsastext) =
$sth->fetchrow_array()) # keep fetching until
# there's nothing left
{
##############################
## remember to add buffer attrib when going live -odq
## This reduces the load on the server
##############################
open(SENDMAIL, "|$sendmailpath -oi -t -odq")
or die "Can't fork for sendmail: $!\n";
# and so on....
Any help would be appreciated.
All the best,
Jim
The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning.
SPONSORED LINKS
| American general life and accident insurance company | American general life insurance company | American general life |
| American general mortgage | American general life insurance | Computer internet security |
YAHOO! GROUPS LINKS
- Visit your group "php_mysql" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
