> > "SELECT firstname, lastname, address FROM TABLENAME ORDER BY lastname
> > Use ASC or DESC to order your query results. When you
> > iterate over the result as Torsten indicated, everything
> > will be in the order you specify.
> In the database table itself, right? Does it make more
> sense to do that than to leave the database alone, read it
> into an array and then sort it anyway I want (there will be
> at least two different sorted lists I want it to produce)?
Sorting in the database should always be the preferred way - should be
quicker than doing it in the application in 9 out of 10 times.
Regards, Torsten Roehr
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php