separate by commas

[jwk811]

take a column in db and separate each input with a comma?

[The Little Guy]

? explain better.

[jwk811]

i want to get a bunch of emails from the database. SELECT email FROM table how can I have it list alll the emails in the database separated by commas?

[.josh]

$sql = "selece email from table";
$result = mysql_query($sql);
while($r = mysql_fetch_assoc($result)) {
   $emaillist .= $r['email'] . ",";
}

 

[DarkWater]

That'll add an extra , in the final output, CV. =P  You may want to put them into an array and implode().

[.josh]

What is it with me and commas today??

 

you can substr or rtrim the prev code or as darkwater suggested:

$sql = "selece email from table";
$result = mysql_query($sql);
while($r = mysql_fetch_assoc($result)) {
   $emails[] = $r['email'];
}
$emaillist = implode(',',$emails);

[The Little Guy]

OR

 

$sql = "selece email from table";
$result = mysql_query($sql);
while($r = mysql_fetch_assoc($result)) {
   $emaillist .= $r['email'] . ",";
}
$emaillist = trim($emaillist,",");

[Ken2k7]

Misspelled "select".