jalmz Posted April 12, 2011 Share Posted April 12, 2011 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.. Link to comment https://forums.phpfreaks.com/topic/233466-how-can-i-display-comma-in-php-mysql-result/ Share on other sites More sharing options...
trq Posted April 12, 2011 Share Posted April 12, 2011 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, ','); } } Link to comment https://forums.phpfreaks.com/topic/233466-how-can-i-display-comma-in-php-mysql-result/#findComment-1200476 Share on other sites More sharing options...
jalmz Posted April 12, 2011 Author Share Posted April 12, 2011 Thank you for the quick reply.. but still the result is theres a comma in the end.. Digitalpoint, phpfreaks, adsense, Link to comment https://forums.phpfreaks.com/topic/233466-how-can-i-display-comma-in-php-mysql-result/#findComment-1200483 Share on other sites More sharing options...
trq Posted April 12, 2011 Share Posted April 12, 2011 Sorry, this.... echo rtrim($return, ','); Should likely be..... echo rtrim($return, ', '); Link to comment https://forums.phpfreaks.com/topic/233466-how-can-i-display-comma-in-php-mysql-result/#findComment-1200487 Share on other sites More sharing options...
jalmz Posted April 12, 2011 Author Share Posted April 12, 2011 wow.. it works like a charm Thank you! Link to comment https://forums.phpfreaks.com/topic/233466-how-can-i-display-comma-in-php-mysql-result/#findComment-1200488 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.