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
> [EMAIL PROTECTED]
> NeoBiz - fábrica de internet
> http://www.neobiz.com.br
>
> ----- Original Message -----
> From: bill
> To: [EMAIL PROTECTED]
> 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
