I need some help with pulling data from a table

[Parker Clack]

I am wanting to take data from my table associate and have it separated by a comma between each entry.

I have the following:

PHP Code:

$associategroups=$DB_site->query("SELECT * FROM associate ORDER BY id DESC");

while ($rows=$DB_site->fetch_array($associategroups)) {
$ass_groupurl=$rows['associateurl'];
$ass_group=$rows['associate'];
eval("\$associatenames = \"".gettemplate("associate_names")."\";");
}

eval("\$associate = \"".gettemplate('associate')."\";");

I have a template called $associatenames with the following:

<a href="$ass_groupurl">$ass_group</a>

and a template called $associate with:

<table cellpadding="4" cellspacing="0" border="1" width="80%" align="center" bordercolor="black">
<tr bgcolor="#ededef"><td>
<smallfont>$associatenames</smallfont>
</td></tr></table> 


Right now as I have it written I am getting on one of the entries listed. How do I set this up so I get something like

entry1,entry2,.....


Thanks,
Parker