diplay results in a list

Anon

I am just learning php/mysql and am trying to write a simple display of emails seperated by a comma or semicolon.
This is my query:
<?
$result = mysql_query("SELECT user_email, perms FROM user_info,auth_user_md5 WHERE auth_user_md5.perms ='member' ORDER BY user_info.user_email ASC") or die(mysql_error());
?>

I have tried every variation of displaying the emails I can think of, but can't seem to get it right. I dont want them on seperate lines, just seperated by a comma or semicolon. Will someone please have mercy on this poor lost sould and tell me what to do here?

chariot

After what you have there I believe you'll want:

while($data = mysql_fetch_array($result)){
echo $data['user_email'] . ', ';
//or you can put it all into one variable
//$emails .= $data['user_email'] . ', ';
}

Anon

Ummm, might be missing something, but as long as the query is valid and returns results, all you'd have to do use use a

$row = mysql_fetch_array()

on the result set in a do..while loop. In the loop, append the $row to a string e.g.

$e-mail_list .= $row[0].";"

and then print $e-mail_list after the loop. Someone will have to confirm if you do or don't have to escape the ";" in a string, though I don't think that you have to.

HTH

glj