email list script timing out

Blake · #1 03-Jul-2006, 22:24

I wrote the following PHP script to send out mass emails for my band (we're not spamming people, they only go out to people who add their emails to the list). The email list is stored in a myql database. This script below (with sensitive information blanked out) accesses the database and sends out an email to everyone on the list. The problem is, sometimes the browser times out before the while loop completes. The list is only getting longer too. Is there a better way to do this? I'm just wondering if someone can point me in the right direction. Thanks.

PHP Code:


include('mailhead.inc');
    
    define ('DB_USER', '********');
    define ('DB_PASSWORD', '********');
    define ('DB_HOST', 'mysql');
    define ('DB_NAME', 'blfoster-render');

    $dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD);
    mysql_select_db (DB_NAME);
    
    $query = "SELECT    email_address AS dr FROM emails ORDER BY email_address ASC";
    $result = @mysql_query($query);

    while ($row = 
    mysql_fetch_array($result,
    MYSQL_NUM))
    {
        mail( $row[0], $subject, $message, "From: news@render-band.com" );
        echo '<br>mailed to ' . $row[0];
    }

TreyAU21 · #2 18-Aug-2006, 08:46

I've accomplished the same functionality in the past with great sucess using CRON to send out daily/weekly/monthly newsletters... however, if you're not necessarily sending newsletters out at a fixed time, you could run the script from the command prompt... php SCRIPT.php.

Try that... however, if you want everything to be accessible from a browser, I'd have to think about it. Approx how many emails is this thing sending out?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bulk Email hosting *** .com Bullet proof hosting	additional2	Web Hosting Advertisements & Offers	1	20-May-2007 13:55
[Include] Doubly-linked List	dsmith	C Programming Language	6	14-Apr-2006 13:12
linked list error message	Krandygrl00	CPP / C++ Forum	4	22-Jun-2005 14:13

email list script timing out

Re: email list script timing out