RE: [PHP] sorting results in PHP

> 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. Why? I still don't see why you can't use an ORDER BY clause. ORDER BY date_column DESC Which will order by year, month, then day. The order by is applied after the GROUP BY, which will accomplish the same thing that you're trying to do in PHP, only much faster. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > 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 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php