[SOLVED] [MySql/PHP] Parsing array items with comma

[chenci]

Hi, i've been working in this code and it seems to have some problems. This is what i want to do

1)A query to select all the users who have recievemail = YES

2)Fetch all the email from the query to an array and put commas to one after another

3)The echo would be something like this

[email protected],[email protected],[email protected],and so on

 

$query = "SELECT * FROM " .s('prefix'). "users WHERE recievemail = 'YES' ORDER BY id DESC";
$result  = mysql_query($query);
$n[] = mysql_fetch_array($result);
foreach ($n as $e)
{
	$mails = $e['email'];
        	$multiplemails .= $mails . ",";
	echo $multiplemails;

And this is what i got

[email protected],

Very weird isn't it? Only one email, and i went to phpmyadmin and there a lot of users with recieve mail = YES. Seems not touching PHP for half a year, can get you now a dose of insanity with this code, as i can't figure out where is wrong.

Mysql version: 5.0.81

Any ideas? Thanks for the time anyway.

Chenci

[ldougherty]

Try this...

 

$query = "SELECT * FROM " .s('prefix'). "users WHERE recievemail = 'YES' ORDER BY id DESC";
$result  = mysql_query($query);
while ($row = mysql_fetch_array($result )) {
      $mails[] = $row['email'];
}

 

Now you have an array with all of your email addresses, Just create the , delimited field now