RE: Sorting data alphabetically
| From: | Tim Ward | Date: | Fri, 15 Dec 2000 08:52:31 +0000 |
| Subject: | RE: Sorting data alphabetically | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-30480@lists.php.net to get a copy of this message | ||
"SELECT ... ORDER by name". I'm just starting to use MySql as well and I use
...
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Refere
nce
Tim Ward
Senior Systems Engineer
Please refer to the following disclaimer in respect of this message:
http://www.stivesdirect.com/e-mail-disclaimer.html
> -----Original Message-----
> From: Ben Wiechman [mailto:neteru@aminal.net]
> Sent: 14 December 2000 22:43
> To: php-general@lists.php.net
> Subject: Sorting data alphabetically
>
>
>
> I'm working on a PHP/MySQL solution and I would like to sort
> the output of
> my select statement in alphabetic order.
>
> I have a table with the following data
> id - int
> parent_id - int
> name - name of item
>
> I would like to sort the data alphabetically by name before I
> print the data
> to the screen. Is there some way I can do this with my select
> statement (and
> I tried to rtfm... lol But I'm pretty new to this.) Or am I
> going to have to
> build the output array in PHP somehow and sort it there?
>
> Ben
>
>