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 <[EMAIL PROTECTED]>
To: <[email protected]>
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
