[Resolved] array - implode

[thines]

Hi folks,

I am trying to get an email list out of the database and send an email. Check it out....

$mq2 = "select DISTINCT id,email from i6users
where id = 3
OR id = 3
OR id = 44";
$resultmq2 = mysql_query($mq2,$i6link) or die (mysql_error());
$rowmq2 = mysql_fetch_array($resultmq2);
while($rowmq2 = mysql_fetch_object($resultmq2)){
$recipients_array = array($rowmq2->email);
}
$recipients_list = implode(",", $recipients_array);
echo "Hello: $recipients_list";

This prints the second email address. Anybody have an idea?

Thanks,
Tim

PS. Sorry for the double post to this newsgroup. I am in a hurry on this one and will post the resolution to the other database forum.

[cgraz]

Have you seen what your array holds? I'd change

$recipients_array = array($rowmq2->email);

to

$recipients_array[] = $rowmq2->email;

Then before going any further, run a foreach loop to print out the values of $recipients_array and make sure it has all the values

foreach($recipients_array as $value) {
   echo $value . "<br>";
}

If the array is structured properly, then proceed to run implode()

Cgraz

[thines]

Thank cgraz

That did it.

-Tim