Aha.
Comments like yours made me look again. It turns out that I could use ORDER BY
with a GROUP BY but I couldn't have it before a HAVING.
Specifically, I had
SELECT ...
GROUP BY $detailsdb.eid
ORDER BY Year, Month, Day
HAVING foobar = $numcatchoices
To fix it I changed the order to
SELECT ...
GROUP BY $detailsdb.eid
HAVING foobar = $numcatchoices
ORDER BY Year, Month, Day
thanks,
bill
"John W. Holmes" wrote:
> > 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
> > > [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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
