php mail to multiple recipients from query result

[tekrscom]

Hi, I was wondering if anyone knows if there is a way to mail to mulitple recipients that are derived from a query?

 

$query = mysql_query("SELECT email FROM users WHERE title = 'Project Manager'");
while ($row  =  mysql_fetch_array($query))	{
	$manager_email = "$row[email]";
                    							}

$contactemail = $manager_email;
$headers .= "To: ".$contactemail."\r\n";

 

So how do you do this when there are more than one manager emails?

 

[chigley]

<?php

$from = "noreply@yoursite.com";
$subject = "Message";
$body = "Hello!";

$query = mysql_query("SELECT email FROM users WHERE title = 'Project Manager'") or die(mysql_error());

while(list($email) = mysql_fetch_row($query)) {
mail($email, $subject, $body, "From: {$from}");
}

?>

[redarrow]

Tell me how this goes ok i love the mail function ok maybe i can inprove the current code for you ok.

[tekrscom]

Sorry it took so long to get back to you, it worked like a charm, thank you very much...