E-Mail Users That Have E-Mail field Filled Out

[creativeink]

My E-mail script is working statically.

 
$inbox = '[e-mail]';

$message .= '</body></html>';
  if(!mail($inbox, "ACES HOCKEY | $title", $message, "From: [e-mail]\n" . "MIME-Version: 1.0\n" . "Content-type: text/html; charset=iso-8859-1")) {
	header('Location: content.php');
  }
  else {
  	header('Location: email-error.php');
  }

I want to implement some code to have my variable $inbox equal to all users emails from a table.

I tried this:

mysql_select_db($database_Creative, $Creative);
$data = mysql_query("SELECT Email_E FROM admin WHERE Email_E IS NOT NULL") or die(mysql_error());
while($info = mysql_fetch_array( $data )) {
print "".$info['Email_E'] . "";
print ","; }
$inbox = "'".$data."';";

I know the problem is how I am connecting my data in my query, the query is pulling the proper information.

Basically I want $inbox variable to be equal to users e-mails seperated by commas like this:

$inbox = '[e-mail],[e-mail],[e-mail],[e-mail]';

Thanks for any help!

[johanafm]

group_concat

[creativeink]

Thank you I researched it and I am not quite sure that is what I am looking for.

<?php require_once('Connections/Creative.php'); ?>
<?php
mysql_select_db($database_Creative, $Creative);
$inbox = mysql_query("SELECT Email_E FROM admin WHERE Email_E IS NOT NULL GROUP BY Email_E ASC") or die(mysql_error()); 
for( $i = 0; $i < $row = mysql_fetch_array($inbox); $i++){
echo $row['Email_E'].";";
}
?>

This query is printing the email addresses with a ; between them.
ex. [email][e-mail];[e-mail];[e-mail][/email];

But what I want is that string equal to a variable called $inbox because my email scripts send on a variable like this:

$inbox='[e-mail];[e-mail];[e-mail]'

So basically how can I get my query equal to a variable $inbox

Thank you!