#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    2
    Rep Power
    0
    Hi

    I have a people subscribing to a newsletter option on of my client's websites. Their addresses are stored in a MySQL table, i have successfully composed a mailshot using forms and BCC: mailed a "bulk" mailshot of about 10 test email addresses and it seems to be okay.

    However, the real email list is already at 800+ addresses and growing quite rapidly.

    Can BCC: handle so many addresses or is there a limit ?

    Or should i be looking at an alternative ?

    Thanks


    gish
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Omaha
    Posts
    5
    Rep Power
    0
    I believe there is not real limit to how many addresses you can put into the BCC list for a mail; the problem is the more address you put into BCC, the longer it takes for the server to send the e-mail out. With 800+ people I can imagine it would get pretty slow. You might be better off using a CGI script to do what you're trying, but as far as I know what you're doing should work.

    Michael
  4. #3
  5. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    England, UK
    Posts
    83
    Rep Power
    15
    Here is the code I use for the mailing list on my site:

    The first page contains a form:
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
    <form action="http://www.musicgoeson.com/admin/mailinglist/send.php" method="GET">
    <b>Subject:</b><br><input type=text name="subject" size="88" value=""><br>
    <b>Message:</b><br><textarea name="message" rows="15" cols="76"></textarea><br><br>
    <input type="submit" value="Submit" align="absmiddle">
    </form>
    [/code]

    send.php contains...

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
    $email = 'webmaster@musicgoeson.com';

    $query = "SELECT * FROM mailinglist";
    $result = mysql_query($query);

    while ($rega = mysql_fetch_array($result)) {
    mail($rega["email"],
    $subject,
    "$message",
    "From: $emailnReply-To:$emailnX-mailer:PHP/". phpversion());
    }
    mysql_free_result($result);
    [/code]

    This pulls the e-mail addresses from a mySQL table (mailinglist) which has two columns: id and email.

    ------------------
    Girish Gupta
    MusicGoesOn.com

Similar Threads

  1. php/mysql Developer needed for online game
    By Lord Melo in forum Project Help Wanted
    Replies: 1
    Last Post: October 29th, 2003, 09:15 PM
  2. PHP/MySQL Application Design/Architecture Books
    By glambert in forum PHP Development
    Replies: 7
    Last Post: April 10th, 2003, 09:52 PM
  3. PHP/MySQL Issues... Please help.
    By misteraven in forum PHP Development
    Replies: 14
    Last Post: August 7th, 2002, 08:03 PM
  4. PHP/MySQL Backend
    By Cujo in forum PHP Development
    Replies: 4
    Last Post: May 15th, 2002, 08:00 PM
  5. Need Qualified PHP/MySQL Programmer
    By ITGL72 in forum PHP Development
    Replies: 0
    Last Post: February 18th, 2002, 11:47 AM

IMN logo majestic logo threadwatch logo seochat tools logo