[PHP-DB] Re: sorting results in PHP

2003-03-18 Thread Edwin Boersma
What about making an array with dates, that you compiled from Year, Month, Date using mktime(), and sort that? Edwin Bill wrote: I have a query that returns results including the fields Year, Month, and Day that I want to sort by date. Because of the nature of the query (it includes a GROUP BY

Re: [PHP-DB] Re: sorting results in PHP

2003-03-18 Thread Doug Thompson
Without knowing your query, it is hard to say whether mysql can return the results you want. However, you can GROUP BY and SORT BY multiple columns in a single query. The following simple query returns a subset of property owners grouped by lastname, alpabetized by group, and ordered by