[SOLVED] Lists and Commas

[steveangelis]

I have created a simple PHP list and after each item I have a comma.  I am unsure though how to have it so that after the query posts the last item it does not have a comma at the end.  Here is my code:

 

while($rowd = mysql_fetch_array($qrd)) {
$qrd2= mysql_query("select * from dpt where id=".$rowd['dpt_id']);
$rrd2 = mysql_fetch_array($qrd2);
echo $rrd2['name'].", ";
}

Those code is nothing fancy but I am unsure to have the last item not have a trailing comma.  Any ideas?

[smerny]

$i = 0;

while($rowd = mysql_fetch_array($qrd)) {
$qrd2= mysql_query("select * from dpt where id=".$rowd['dpt_id']);
$rrd2 = mysql_fetch_array($qrd2);

if($i > 0)
  echo ", "

echo $rrd2['name'];

$i += 1;
}

 

try this

[Garethp]

$Content = "";

while($rowd = mysql_fetch_array($qrd)) {
$qrd2= mysql_query("select * from dpt where id=".$rowd['dpt_id']);
$rrd2 = mysql_fetch_array($qrd2);
$Content .= $rrd2['name'].", ";
}
$Content = substr_replace($string ,"",-1);
echo $Content;

[steveangelis]

That works thank you.