Re: Displaying results from a query properly.

Thanks, works like a charm (had to make is -2 instead of -1 as it added a space after each result). Hadn't thought of something so simple. Regards, Alex. On 24/3/06 16:22, "Bastien Koert" <bastien_k@hotmail.com> wrote: > Build it up as a string and remove the trailing comma at the end of the loop > > do { $sHTML .= ''.$administrators['username'].', ';} > while ($administrators = mysql_fetch_assoc($administrators_result)) > > $sHTML = substr($sHTML, 0, strlen($sHTML)-1); > > echo $sHTML; > > ?> > > Bastien > > > >> From: Alex Major <alex.major@allydm.co.uk> >> To: <php-db@lists.php.net> >> Subject: [PHP-DB] Displaying results from a query properly. >> Date: Fri, 24 Mar 2006 16:19:10 +0000 >> >> Hi there. >> This isn't a major problem, more of a matter of aesthetics. >> Basically, I have a query which pulls a list of usernames from the database >> (based on their user level). >> >> These users should then listed in this fashion. >> >> Administrators: allydm, alex, mike, dave >> Moderators: big 'd', frank, william >> >> However, the loop that I have returns the results like this... >> >> Administrators: allydm, alex, mike, dave, >> Moderators: big 'd', frank, william, >> >> There is a , after each username, including the last one in that list. I'm >> after a way of making the usernames display with a , after them, apart from >> the last username in that set of results. >> >> My current display code is: >> >> <?php >> do {echo ''.$administrators['username'].', ';} >> while ($administrators = mysql_fetch_assoc($administrators_result)) >> ?> >> >> How could I change to display the results in the fashion that I'd like? >> Many thanks for any suggestions. >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> > >