mysql result in array

[hysterical]

hey,
Im building something that stores email addresses there stored in a database
but if I want to view all the email addresses with a , between them so I want to do this in a array and implode them

<?php
include('config.php');
$sql = "SELECT * FROM emails";
$query = mysql_query($sql);

while($row = mysql_fetch_array($query)){
       $array = array($row['emails']);
}
$list = implode(',' , $array);
echo $list;
?>

but he only shows the last email address from the database and all the others are not 'echo-ed'

if someone know a solution please share 😉

Grtz Hysterical

[johanafm]

 $array[] = array($row['emails']); 

[hysterical]

johanafm;10922694 wrote:

 $array[] = array($row['emails']); 

well that gives me something
but not the email addresses
I just get
Array,Array
and if I add a other one into my database
Array,Array,Array

[hysterical]

srry for dubble post, I diden't find the edit button

you have to do

$array[] = $row['emails'];

that solves the problem