Re: sorting results in PHP

Hi André, Sorting like that doesn't get it sorted by date. Each row has a lot of fields. It actually needs to be sorted three times by three fields, Year, Month, and Day. Because the query uses a GROUP BY statement, I can't sort it in the query. André cupini wrote: > Bill > Try this: > > while ($crow=mysql_fetch_array($cresult)) { > $therow[]=$crow; > } > sort($therow); > > André Cupini > Programador > andre@neobiz.com.br > NeoBiz - fábrica de internet > http://www.neobiz.com.br > > ----- Original Message ----- > From: bill > To: php-general@lists.php.net > Sent: Monday, March 17, 2003 11:54 AM > Subject: [PHP] sorting results in PHP > > 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 General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php