mailing list problem

[fimbria]

hi ,

i have a simple form that a "user" can enter their name, email and some comments, then when the form is submitted, it emails an email account(e.g [e-mail]), with details that the user has submitted

but i wish to adapt the code, so that i can drag, say 50 email address off a MySQL database, and email all the address in one go, with whatever i type in the comments section of the form.

has anybody got any suggestions, how i could achieve this??

this is the code i have so far......

<?php
if($sentemail == "2"){
include("sorry.php");

}else{

$num = $sentmessage + 1;
setcookie("sentemail","$num",time()+600); //set the cookie

$email = "Sender Name:\t$name\nSender E-
Mail:\t$thereemail\nMessage:\t$message\nIP:\t$REMOTE_ADDR\n\n";
$to = "webmaster@someserver";
$subject = "Site Message";
$mailheaders = "From: $thereemail <> \n";
$mailheaders .= "Reply-To: $thereemail\n\n";
mail($to, $subject, $email, $mailheaders);
include("thanksecho.php");
}
?>

thanks
php_2003

[WindomEarle]

You want to send e-mail to all (or, say, 50) users from database, right?

try something like this:

//here goes functions to connect to mySQL and select database

$query = mysql_query("SELECT email from $table"); //say email - name of a column where emails are stored

$num = mysql_num_rows($query);

for ($i=0; $i<$num; $i++) {
$a = mysql_fetch_array($query);
$to = $a["email"]; 
mail ("$to", "$subject", "$body", "$additional_headers");
}

[fimbria]

ok thanks, WindomEarle

i take it this will email, every email address till it runs out of address to retirieve from the database..?

also i want the mail to be sent as BCC: , can i just enter this in the mail ( $to, $BCC???? $subject, etc... )

thanks for your help