Richard Lynch wrote:
On Thu, May 3, 2007 10:00 am, Stut wrote:
Richard Lynch wrote:
$query = "select tag, popular from (select tag, count(*) as
popular
from entry_tag group by tag order by popular desc limit 100) as p
order by tag";
I'm no expert, and I have no way to test this, but the following
should
work and gets shot of the sub-select...
select tag, count(1) as popular
from entry_tag
group by tag
order by popular desc, tag
limit 100
But the whole point is to order by tag in the end, not popular desc...
In the final output, the tags are in alpha order for easy scanning
across.
The popularity is rendered in larger/bolder/darker text for, errr,
that not-quite-focuesed-zoom-in-on-big-things look. :-)
The inner query sorts by popularity to get the "Top 100".
The outer query sorts that inner result alphabetized.
I don't *think* you can get that in a single non-join non-nexted
query, but I ain't no SQL expert either...
Ahh, right, with you. Indeed, I can't see a way to do that either.
Ignore me, go about your business.
-Stut
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
