Send email to email addresses stored as variables

[renegade78]

Hi,

I'm new to the forum and was wondering if anyone could help me!

Basically, I'm trying to create a script that will send an email to a group of recipients that are created elsewhere, plced in mysql database and then recalled and added as a variable to which the email is sent.

The problem I have is that I'm unsure how to get the email addresses from the database.

I've put a bit of code below. The idea is that the email addresses are taken from the db. This doesn't work. the email will go to the example address. How can I assign the email addresses from the db to individual variables?

$query = "SELECT * FROM townfield"; 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
    echo $row['email'];
    echo "<br />";}
 
 
if($fao == "1") {
$attention = "All Staff";
$recipients = $row['email'] . "," . "[e-mail]";}

Many thanks to anyone who could give me a hand with this!!

[bilibytes]

I am not sure if I understood you but try this:

 
    $query = "SELECT * FROM townfield"; 
    $result = mysql_query($query) or die(mysql_error());
    while($row = mysql_fetch_array($result)){
        $emailsArray[] = $row['email'];
    }
 
    $recipients = implode(', ', $emailsArray);//output [e-mail], [e-mail], [e-mail]...
}
 

or within the loop:

 
    $query = "SELECT * FROM townfield"; 
    $result = mysql_query($query) or die(mysql_error());
    $recipients = '';
    while($row = mysql_fetch_array($result)){
        $recipients .= $row['email'] . ', ';
    }
    //subtract the last ', '
     $recipients = substr($recipients, -2);
 

that's it, don't know which is faster..

Hope it helps,
Cheers

Bilibytes

[renegade78]

Thanks, I'll give it a go!

Much appreciated!

[Dormilich]

Swiftmailer offers a method to send emails as batch

[renegade78]

First one worked a treat! Thanks a lot.