Re: Table sorting problem
| From: | Gerry Danen | Date: | Fri, 13 Jan 2006 06:52:16 +0000 |
| Subject: | Re: Table sorting problem | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41034@lists.php.net to get a copy of this message | ||
On 1/12/06, Miles Thompson <miles@allnovascotia.com> wrote:
> I'd cheat and add a numeric field, let's call it num_rank, ranking the
> offices in the order you want them displayed, e.g.
>
> President 10
> Vice-President 20
> .
> .
> .
> Board Member 50
> Board Member 50
> Board Member 50
>
> and change the query to
> SELECT * from members order by num_rank, last_name
> which would provide officers and board member in the order you want them,
> automatically sorted by name.
This is exactly how I implemented this page:
http://www.arls-lilies.org/h/board.php
--
Gerry
http://portal.danen.org/