Proper Comma Construction?

[kaotic]

Here's the code that I'm working with:

$GetUser = $DB_site->query("select s.*,u.* from ".TABLE_PREFIX."session s
left join ".TABLE_PREFIX."user u on (u.userid = s.userid) where s.location like '%test.php%'");
while($UserIN = $DB_site->fetch_array($GetUser)){
if(!$store_c[$UserIN['userid']]){
if($UserIN['userid']){
$activeusers .= "<a href='member.php?u={$UserIN['userid']}'>{$UserIN['username']}</a>, ";
}
}
}

I'm using it to contruct a users online list, but I'm having a problem with comma placements. Using the code above, a comma is placed once after each users name, including the last one to be listed... so it ends up looking like:

user1, user2, user3,

Can anyone help me rid myself of the final comma? Assistance would be most appreciated.

[filburt1]

Add everything to an array in the loop, then use implode(", ", $arrays_name) to add the commas.

I also wrote an English sentence comma delimiter in Java it if helps (operates on an array of Objects).

[kaotic]

Ehh... I apologize for my ignorance, but I'm not very familiar with PHP. Could you further elaborate?

[filburt1]

$users = array();

$GetUser = $DB_site->query("select s.*,u.* from ".TABLE_PREFIX."session s
left join ".TABLE_PREFIX."user u on (u.userid = s.userid) where s.location like '%test.php%'");
while($UserIN = $DB_site->fetch_array($GetUser)){
if(!$store_c[$UserIN['userid']]){
if($UserIN['userid']){
array_push($users, "<a href='member.php?u={$UserIN['userid']}'>{$UserIN['username']}</a>");
}
}
}

$activeusers = implode(", ", $activeusers);


edit: BTW, you badly need to add more whitespace to your code...it is very hard to read with it all scrunched together.

[kaotic]

Aye! Well, thank you for that. I appreciate the assistance. :)