Re: Re: sorting results in PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux