mysql_fetch_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);

$recipients_list = implode(",", $rowmq2);
echo "Hello: $recipients_list";

This only repeats the id=3 email twice. Anybody have an idea?

Thanks,
Tim

[thines]

Here is the solution..

$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[] = $rowmq2->email;
}
$recipients_list = implode(",", $recipients_array);
echo "Hello: $recipients_list";

-Tim