Re: sorting results in PHP

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