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.

I hope this is not a product quality code you are writing.. sending newsletters via bcc will give you no possibility to track which mails were sent successfully(what are you doing, if your script timeout?).. use pear::Mail_Queue instead.. — Peter Parker
– Peter Parker, Commented Jul 13, 2010 at 0:16

yretuta · Accepted Answer · 2010-07-13 00:08:31Z

2

$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 :)

answered Jul 13, 2010 at 0:08

yretuta

8,14118 gold badges86 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1