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.. Quote 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, ','); } } Quote 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, Quote 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, ', '); Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.