How to write an sql query to print all rows in a column in a single line seperated by commas?

Question

How to write an sql query to print all rows in a column in a single line seperated by commas?

Answer 1

$query = "select `columname` from `tablename` where 1";

$list = mysql_query($query);

while ($lst = mysql_fetch_array($list))

echo ($lst[0] . ", " );

mysql_free_result($list);