Right off... if you have a hosting company that isnt interested
in your troubles - > DROP THEM! Nothing bugs me more than
a service company who wont provide service. They will take
your monthly check but wont help with problems.
Jim Byrne wrote:
>Hi,
>
>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.
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
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.
