Re: Re-sequencing a query result set with MYSQL

[Paul DuBois]

At 13:27 -0600 9/14/02, Dharmendra sawh wrote:
>Hi Folks,
>
>Here is my situation:
>
>Me query for my MYSQl table is using count on a specific column and also
>using the group by clause to get the number of occurrences of the group by
>column in the table.   After I get the result set I wan to order the results
>by the count in descending order.

With an ORDER BY clause.  But that answer seems so obvious that I suspect
there's something unusual about your query that this doesn't work?
Maybe you can show the query.

>
>Does anyone know how to do this?  I also would like to do this to reorder
>the display on the page without re-reading the DB.
>
>Thanks,
>                 Dhar.