HTML Mime Mail class and BCC

[mlewczuk]

Hello friends,
I'm using HTML Mime Mail class by Richard Heyes to send newsletter for hundreds of people. Right now I send newsletter separately to each subscriber -> each email looks like this:
TO: SUBSCRIBER EMAIL
FROM: ....
SUBJECT: ...
BODY: ...

But it's not so effective as sending each newsletter only once to all of my subscribers, using BCC. HTML Mime Mail class gives possibility to send e-mail using BCC but I have problems with that. I dont know how to build an array with recipients, default looks like this:

'recipients' => array
(
'richard@[10.1.1.2]', // header TO recipient
'[e-mail]' // header BCC recipient
),

To send e-mail for many persons I shoud repeat second element ( BCC -> blindcopy...). But I dont know how to do it dynamically -> all data about subscribers are gathered in MySQL database. So can anyone tell me how to build this array ???

I will be thankful for your help. 😃

[jowatkins]

This should build your array:

$result = mysql_query("SELECT email FROM table");
$num_results = mysql_num_rows($result);
$emails = array();
//use the for loop to populate the array with the emails from the query
for ($i; $i<$num_results; $i++)
{
$row=mysql_fetch_object($result);
$emails[]=$row->email;
}