|No such thing as a small change|
ORDER BY COUNT(*)?by peppiv (Curate)
|on Mar 20, 2002 at 15:31 UTC||Need Help??|
peppiv has asked for the wisdom of the Perl Monks concerning the following question:
I'm reading from a MySQL database using DBI/DBD. I want to be able to read the results that equal a certain query, print them, their count, their percentage to another number (not important what number it is) and print them in order by count.
Here's what I'm using (could be written better than this I'm sure):
This gives me something like this:
I'd like it to return this:
ORDER BY COUNT doesn't work. I put in ORDER BY DESC just to see how far I could take it. Any ideas?
"Lost in (cyber) Space"