Help email user question

ahowardmiller · #1 (**permalink**) 04-18-06, 05:43 PM

I'm trying to write a script to email all the users of my database and for the life of me I can't get it to work. I've tried everything I could find on this and other fourms and nothing is working.
I have a table in my database called users with a row called email to store their addresses. I have a form that posts the subject, message, and sender, but I can't figure out how to send it to multiple recipients. It works just fine with one recipient but if I query the database for all the email address it only sends it to the first email address.
Any help would be appreciated.

Here's the code I'm using:

PHP Code:


			
The Form page:

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Send Users Email Area</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Edit User Area</title>

<body>

<form method="post" action="sendmail.php">

Email: <input name="sender" type="text"><br>

Subject: <input name="subject" type="text"><br>

Message:

<textarea name="message" rows="10" cols="30">

</textarea>

<input type="submit">

</form>



</body>

</html>

PHP Code:


			
The sendmail.php

<?php

include ('config.php');

/*Here we are going to declare the variables*/

$message = $_POST['message'];

$subject = $_POST['subject'];

$sender = $_POST['sender'];

 unset($email); 

$counter=0; 

$res=mysql_query("SELECT email FROM users"); 

$numb_user2=mysql_num_rows($res); 

$numb_user=$numb_user2 - 1; 

while($all = mysql_fetch_object($res) ): 

$email .= $all->email; 

if($counter < $numb_user) $email .= ", "; 

$counter++; 

endwhile; 

//Save visitor name and entered message into one variable:

$mailheader = "From: $sender\r\n";

$mailheader .= "Reply-To: $sender\r\n";

$mailheader .= "MIME-Version: 1.0\r\n";

mail($email, $subject, $message, $mailheader) or die("Failure!");

echo "Thank You!";

?>

Nico · #2 (**permalink**) 04-18-06, 06:22 PM

Try this

PHP Code:


			
<?php

include ('config.php');



/*Here we are going to declare the variables*/

$message = $_POST['message'];

$subject = $_POST['subject'];

$sender = $_POST['sender'];



//Save visitor name and entered message into one variable:

$mailheader = "From: $sender\r\n";

$mailheader .= "Reply-To: $sender\r\n";

$mailheader .= "MIME-Version: 1.0\r\n";



$query = mysql_query("SELECT email FROM users");



while ($row = mysql_fetch_array($query))

{

    mail($row["email"], $subject, $message, $mailheader) or die("Failure!");

}



echo "Thank You!";



?>

ahowardmiller · #3 (**permalink**) 04-18-06, 08:59 PM

It worked. Is there anything I need to worry about when the users get into the hundreds? Thanks again. I tried row before but couldn't get it to work. Have a great day.

Take care,
Aaron

One additional question. What if I wanted to make the email bcc instead of To?