hello.
say i have a mysql table filled with user info (group name, name, email, ...etc). and then i have a webpage written in php and html that displays this table. i want to write a query that will retrieve all the emails associated with a specified group name so that i can use this list of emails to make a mailto hyperlink.
here is what i have:
<?
$erecord= "select email from table_name where groupname='some_group_name'";
$eresult = $db->query($erecord);
while ($eresult->fetchinto($elist)){echo $elist[0];}
?>
this will print out an email list like this:
abc@boa.comxyz@boa.comdef@boa.com
i would like to have each email separated by a comma so that i can make this a functioning email list for outlook. any suggestions?? thanks a lot.