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 zipcode from a database I have at hand. Mysql
Version 4.0.1a
select last_name, zipcode from mytable where last_name like sm% group by last_name,
zipcode order by last_name, zipcode;
You could simplify your life by combining your y,m,d fields into a single DATE type,
too.
Doug
On Tue, 18 Mar 2003 10:36:40 +0200, Edwin Boersma wrote:
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 statement), I cannot
sort it in the query.
How can I sort the results?
I tried to use asort() while designating the field but that didn't work.
while ($crow=mysql_fetch_array($cresult)) {
$therow[]=$crow;
}
asort($therow[Year]);
reset($therow);
asort($therow[Month]);
reset($therow);
asort($therow[Day]);
reset($therow);
ideas?
kind regards,
bill
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php