Remove ending comma on while loop

[Mr Chris]

Hi Guys,

I have this code:

[code]
<?php

$sql = "SELECT * from cfm_lower_level_story_categories WHERE tl_section_id=1"; 
$result = mysql_query($sql) OR die(mysql_error()); 

while ($row = mysql_fetch_assoc($result)){ 
  rtrim( ', ' );
  echo '"';
  echo $row['subsection_name'];
  echo '"';
  echo',';
}
?>

 

However, as you can see I have an ending comma:

 

  echo',';

 

How can I remove that comma on the last loop?  I thought it was done using rtrim, but I can't see how?

 

Thanks

 

Chris[/code]

[shocker-z]

try this mate

 

<?php

$sql = "SELECT * from cfm_lower_level_story_categories WHERE tl_section_id=1"; 
$result = mysql_query($sql) OR die(mysql_error()); 
$i=0;
while ($row = mysql_fetch_assoc($result)){ 
  if ($!==0) {
    echo',';
  }
  rtrim( ', ' );
  echo '"';
  echo $row['subsection_name'];
  echo '"';
  $i++;
}
?>

 

 

done it the opposite way as it it echo's after the lines before

 

 

Regards

Liam