RE: [PHP-DB] Displaying results from a query properly.
On 24 March 2006 16:40, Alex Major wrote:
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.
On 24/3/06 16:22, Bastien Koert [EMAIL PROTECTED] 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);
You don't need a strlen() call here, as substr understands count from the
right notation:
$sHTML = substr($sHTML, 0, -1);
... or, with Alex's correction:
$sHTML = substr($sHTML, 0, -2);
Cheers!
Mike
-
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Headingley Campus, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Displaying results from a query properly.
On Fri, Mar 24, 2006 at 04:19:10PM +, Alex Major wrote: 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, As an alternative to what the others have said you could use trim() also. Specifically the second, and optional, parameter. http://www.us2.php.net/trim --Greg -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Displaying results from a query properly.
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: php-db@lists.php.net
Subject: [PHP-DB] Displaying results from a query properly.
Date: Fri, 24 Mar 2006 16:19:10 +
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
Re: [PHP-DB] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Displaying results from a query properly.
Date: Fri, 24 Mar 2006 16:19:10 +
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
