How to place data on mysql to php array()

Question

I have about 50 users in a database and I want to send them a newsletter.

$result = mysql_query("SELECT email FROM users") or die(mysql_error());  
$row = mysql_fetch_array( $result ); // had 50 emails

How do I put the $row['email'] into the mail code below.

$m->setBcc(Array("[email protected]", "[email protected]","[email protected]"));

Let me know.

Answer 1

$recipients = array();

while($row=mysql_fetch_array($result))
{
 $recipients[] = $row['email'];
}

$m->setBcc($recipients);

tell me if it doesn't work and I'll immediately delete it :)