How can I display comma "," in php mysql result?

[jalmz]

Hi guys I'm having problem on how to display my php mysql result like this..

 

Digitalpoint, phpfreaks, adsense

 

here's my code

 

$result = mysql_query ("SELECT dateline, dateline_from, eventid, title FROM vb_event WHERE calendarid = 1 AND dateline_from >= '$day_before' ORDER BY dateline_from LIMIT 2"); 
while($row = mysql_fetch_array( $result )) {  
echo "<a href='/forum/calendar.php?do=getinfo&e=" . $row['eventid'] . "&c=1' title='". $row['title'] . "' style='font-size:12px;'>" . $row['title'] . "</a> " ;
}

 

the result is Digitalpoint, phpfreaks, adsense,

 

how to remove the "," in the end?  it should be like this..

 

Digitalpoint, phpfreaks, adsense with no , comma  in the end..

 

Thank you..

[trq]

if ($result = mysql_query ("SELECT dateline, dateline_from, eventid, title FROM vb_event WHERE calendarid = 1 AND dateline_from >= '$day_before' ORDER BY dateline_from LIMIT 2")) {
  if (mysql_num_rows($result)) {
    $return = '';
    while ($row = mysql_fetch_array( $result )) {  
      $return .=  "<a href='/forum/calendar.php?do=getinfo&e=" . $row['eventid'] . "&c=1' title='". $row['title'] . "' style='font-size:12px;'>" . $row['title'] . "</a>, ";
    }
    echo rtrim($return, ',');
  }
}

[jalmz]

Thank you for the quick reply.. but still the result is theres  a comma  in the end.. 

 

Digitalpoint, phpfreaks, adsense,

[trq]

Sorry, this....

 

echo rtrim($return, ',');

 

Should likely be.....

 

echo rtrim($return, ', ');

[jalmz]

wow.. it works like a charm  Thank you!