remove last occurance of a comma

[condoug]

Hi all

I have the following code which loops and displays names of people as a long string, using commas to separate each one.

How can I remove the last comma of the last name displayed?

		while ($row 	= mysql_fetch_array($res)) {
			$name		=	stripslashes($row['name']);

		echo "	$name,";
	}
	mysql_free_result($res);

Thanks for reading.

[Xager]

Check how many rows that are affected by using mysql_num_rows($res) and then have a counter which starts at 1 and at the end of the loop increases by one, and then in the loop do a if($counter < mysql_num_rows($res))

[NogDog]

A couple other alternatives:

$names = array();
while($row = mysql_fetch_array($res)) {
   $names[] = stripslashes($row['name']);
}
echo implode(', ', $names);

// . . . or . . . //

$names = '';
while($row = mysql_fetch_array($res)) {
   $names .= stripslashes($row['name']).', ';
}
echo rtrim($names, ', ');

PS: If you need to use stripslashes() for data being read from your database, there is something wrong with the way you are putting it in there (or, in fact, you do not need the stripslashes).