Displaying results from a query properly.

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:

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

RE: 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
>To:
>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:
>
> >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: 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" 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
>> To:
>> 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:
>>
>> >> 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: 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.
>=20
> On 24/3/06 16:22, "Bastien Koert" wrote:
>=20
> > Build it up as a string and remove the trailing comma at the end of
> > the loop=20
> >=20
> > do { $sHTML .=3D ''.$administrators['username'].', ';}
> > while ($administrators =3D mysql_fetch_assoc($administrators_result))
> >=20
> > $sHTML =3D substr($sHTML, 0, strlen($sHTML)-1);

You don't need a strlen() call here, as substr understands "count from the =
right" notation:

$sHTML =3D substr($sHTML, 0, -1);

.... or, with Alex's correction:

$sHTML =3D 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: m.ford@leedsmet.ac.uk
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211=20


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: Displaying results from a query properly.

On Fri, Mar 24, 2006 at 04:19:10PM +0000, 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