Re: [PHP] sorting results in PHP

2003-03-17 Thread bill
herow); > > > > > > André Cupini > > > Programador > > > [EMAIL PROTECTED] > > > NeoBiz - fábrica de internet > > > http://www.neobiz.com.br > > > > > > - Original Message - > > > From: bill > > >

RE: [PHP] sorting results in PHP

2003-03-17 Thread John W. Holmes
> > 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

Re: [PHP] sorting results in PHP

2003-03-17 Thread Marek Kilimajer
Use temporary table, it is simple and fast 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? kind

Re: [PHP] sorting results in PHP

2003-03-17 Thread Erik Price
bill wrote: 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. MySQL offers a DATE column type. Yo

Re: [PHP] sorting results in PHP

2003-03-17 Thread 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

Re: [PHP] sorting results in PHP

2003-03-17 Thread André Cupini
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

[PHP] sorting results in PHP

2003-03-17 Thread bill
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