In a member's online script...how do i get rid of the last comma?

AutomatikStudio

I've got a "Member's Online" script that lists the current active members on the site...each member name is seperated by a comma using this:

echo ($row['playername'].", ")

but how what do i need to do so that the last name doesn't have a comma after it?

LordShryku

looks like a comma and a space. use substr() or rtrim() to remove it.

AutomatikStudio

But how do I remove it from the last one? Like that is looped until the members are listed...how do I make it only remove the comma and space from the last member listed...

LordShryku

show us more code, speciically the loop. You may be able to just avoid it all together. If this is a DB call, and your pulling it from a while() loop, you can add an internal counter with a conditional saying

if($counter == mysql_num_rows($result)) {
   // don't add the comma
}

AutomatikStudio

Here's the current query:

$result = mysql_query("SELECT * FROM km_users WHERE (UNIX_TIMESTAMP() < (UNIX_TIMESTAMP(lastclick) + 300))"); 
	if (!$result) { 
     	echo("<p>Error performing query: " . mysql_error() . "</p>"); 
    	exit(); 
   	} 
	while($row = mysql_fetch_array($result)){
	echo ($row['playername'].", "); }

LordShryku

k, so like I said. Just a matter of adding a bit to the loop.

$rows = mysql_num_rows($result); // number of rows returned
$i=1; // internal counter
while($row = mysql_fetch_array($result)) {
   echo $row['playername']; 
   if($i < $rows) {
      // while we haven't hit the last row, add commas
      echo ", ";
   }
   $i++; // increment counter
}