On 1/12/06, Miles Thompson <[EMAIL PROTECTED]> 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/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php