Fwd: Re: [PHP] Mass Mailing with PHP & MySQL

----- Forwarded message from rw@xend.net ----- Date: Sun, 19 Jan 2003 22:07:34 -0700 From: rw@xend.net Reply-To: rw@xend.net Subject: Re: [PHP] Mass Mailing with PHP & MySQL To: Justin French <justin@indent.com.au> Is Peter McNulty out there anywhere? Don't have a lot of experience with mailing scripts, but I use the one found at codingclick.com Anyone else? RW Quoting Justin French <justin@indent.com.au>: ### A while() loop will, at some point, break. this is because the script ### will ### timeout on the server before you send to any large lists... when I say ### large, this could be 100 address', or could be 10,000 -- it all depends ### on ### your server/ISP and server load at certain times. ### ### A better/simpler solution would be to build a Bcc header field using the ### while loop, then only send ONE email to 1000's of email address' via the ### Bcc ### field, just like you would from Outlook. ### ### BUT, your host may impose restrictions on how many emails you can send in ### one Bcc... my host has a limit of 100. ### ### So, I tend to send a few emails of 50-ish people per email to my list, ### balancing the two above issues. ### ### ### There are also some simple/complex classes on phpclasses.org (esp the one ### by ### manuel lemmos) which can overcome both these problems, with various ### methods. ### ### I haven't used them yet, basically because I don't see the need yet, ### given ### my small lists. ### ### ### Justin ### ### ### ### ### ### ### ### ### ### on 20/01/03 3:21 PM, Tim Thorburn (immortal@nwconx.net) wrote: ### ### > Hi, ### > ### > I'm working on a mailing solution for a client. His site collects ### email ### > address from a 'Send this site to a friend' page (user enters their ### email ### > address and up to 10 other addresses - a message is then sent to the 10 ### > addresses from the users own email address). The addresses are then ### stored ### > in a MySQL database - a column for the users email address, and then a ### > column each for the additional 10 addresses. ### > ### > Now the client would like to have the ability to send an email to all ### > addresses collected at once - to inform the addresses of a sale, etc. ### I'm ### > guessing for this to be done, I'd have to select all the DISTINCT email ### > addresses from the 11 columns (users email, and the 10 addresses), then ### use ### > a loop to send the mail out. ### > ### > I had planned on using PHP's mail() function - does anyone know of any ### > limitations imposed by this method? Normally, I'd contact the ISP and ### ask ### > them directly, however it's been several weeks since they've answered ### the ### > phones. ### > ### > Does anyone have any other/better options that I should pursue? This ### will ### > be my first mass mailing typed job so I'm not really sure where to begin ### or ### > if I'm on the right path at all. ### > ### > Thanks ### > -Tim ### > ### > ### ### ### -- ### PHP General Mailing List (http://www.php.net/) ### To unsubscribe, visit: http://www.php.net/unsub.php ### ### ----- End forwarded message -----