Mass email

[Anon]

Hey all. .I am still new to the programmign world.. I have a page where users can add their email address to a list.. This is stored in a db.. Now that works fine.. but my question is what is the best way to send an email to all of those in the db. I just want to be able to type my message.. attach my files.. and click send and have it go to all my members.
BTW it is an access db.. I know it sucks.. heh. but customer specs what can you do.. Thanks much everyone

[gio2k]

Just use mail()

Search for it in the php documentation.

You can build the mailing adresses list from your database. Just retrieve all records and concatenate all the addresses in a string, separated by ' , '

-Gio-

[Anon]

thanks for the help.. One little addon to this is .. what is teh correct syntax for building i guess a do while loop to pull the first addy, then add the , or ; to separate the addys then pull the next one.. etc until EOF ..

Thanks much

[Anon]

Try this:

$sql = "select emailaddress from table"
$result = odbc_exec($db, $sql);
while (odbc_fetch_row($result)) {
$email = odbc_result($result, 1);
$str .= $email .", ";
}
mail($str,'subject','msg');

I am not use to using ODBC/Access so you may need to tweak the code a bit to get it to function properly.

John
[ black dog, brown dog, you decide @ smashedbug.com ]