arrays to string: implode?

[timbr8ks]

So, I have a whole bunch of email addresses in my database, and I want to turn them all into a string so that I can email everyone. Simple, right? I thought I simply used the implode() function.

Here's what I'm doing:

get the email addresses

$sql="SELECT email FROM person";

if ($result=mysql_query($sql)) {

  $row=mysql_fetch_array($result);
  $addresses=implode(", ", $row);

  echo $addresses;

}

Only, it doesn't work. Although there are 230 email addresses in the database, what I end up with is a single comma and no email addresses.

What am I doing incorrectly? How best do I turn the collection of email addresses into a string so that I can drop them all into a bcc field?

Thanks.

[drew010]

try this:

$sql = "SELECT email FROM person";
$res = mysql_query($sql);

while($data = mysql_fetch_array($res)) {
$addresses .= $data->email . ",";
}

$addresses = substr($addresses,0,strlen($addresses) - 1);
// that is to strip the comma off the end of the list.

[kevinc]

Yeah, drew010 is correct.

When you're performing a query that will return more than one result, you have to "fetch" each row, as such. The error in your code, is you're not actually "fetching" the email addresses, so you can't expect to have them in an array.

I'd suggest using the mail command inside the while loop, or, alternatively, build up a variable of the addresses, and use implode outside the loop.

while($row = mysql_fetch_array($result)) {
     $emails[] = stripslahes($row["email"]);
}
     $addresses = implode(",",$emails);

You can take it from there.

Hope it helps.

Kev.