[thelist] Selecting most active n blogs [php/mysql]
Martin Kuplens-Ewart
martin at takingitglobal.org
Fri Apr 12 13:42:00 CDT 2002
So...
...help needed [for feasability - yes/no answer for client]
Is there another way of doing what I'll describe below
[summarised as selecting 5 most commented-on blogs from a table]
Select all blogs
For each, grab number of comments [from separate table]
Then evaluate number of comments, rejigging position in results, until 5
with most comments have been found.
Is there a faster way of doing this?
Thanks
-m
More information about the thelist
mailing list