[SOLVED] Quick Question, Remove Comma

[hoopplaya4]

How would I go about removing the last comma in the following code:

 

<?php
$sql = "SELECT * FROM tblUsers";
require("../connection.php");
$rs=mysql_db_query($DBname,$sql,$link) or die(mysql_error());
while($row = mysql_fetch_assoc($rs)) {
$users = $row['usrID'];
echo $users;
echo ","; }

It outputs:

1,4,6,8,9,

 

However, I need to remove the last comma, and I'm not sure how to do this within a "while" statement.  Thanks.

[sasa]

<?php
$comma = '';
$sql = "SELECT * FROM tblUsers";
require("../connection.php");
$rs=mysql_db_query($DBname,$sql,$link) or die(mysql_error());
while($row = mysql_fetch_assoc($rs)) {
$users = $row['usrID'];
echo $comma,$users;
$comma = ","; }

 

[Yesideez]

$query=mysql_query("SELECT * FROM tblUsers");
$numrecords=musql_num_rows($query);
while ($row=mysql_fetch_assoc($query)) {
  echo $row['usrID'].($numrecords-->0 ? ', ' : '');
}

[taquitosensei]

I would do it this way

 

<?php
$sql = "SELECT * FROM tblUsers";
require("../connection.php");
$rs=mysql_db_query($DBname,$sql,$link) or die(mysql_error());
while($row = mysql_fetch_assoc($rs)) {
$users[] = $row['usrID'];
}
echo implode(",", $users); 

[hoopplaya4]

Thanks all!  Last method worked perfect for me.