Hottest Threads!

[Sharif]

Is there any way I can make a mysql query where I can get like the 3 most popular threads on the forum? And list it like this:

- Thread Title (x Posts)
- Thread Title (x Posts)
- Thread Title (x Posts)

?

I am running Vb 3.0.4.

[Dean C]

What do you mean? The three threads on the forum that have the most replies?

[Sharif]

The three most ACTIVE threads! I guess the three with the latest replies will do too.

[Dean C]

By latest how do you mean? What would you define a timespan as latest for? The last day? The last week? The last month? :)

[Sharif]

Latest I mean with the threads that has the most recent posts. Like as soon as I make this post, this thread will have the most recent post... get it?

[rake]

You should look around. It's already been done. Search for "latest threads" or something along that line.

[Dean C]

Ah yes getting the last x posts has been asked many times before. You had me confused for a while there ;) Do a search and ye shall find.

[Sharif]

I did a search a few mins back and it seems no one ever posted a solution for vb3 yet... a lot of questions, no answers.

[Link14716]

The three with the most replies:

SELECT * FROM thread ORDER BY replycount DESC LIMIT 3

The three with the most views:

SELECT * FROM thread ORDER BY views DESC LIMIT 3

The three latest updated threads:

SELECT * FROM thread ORDER BY lastpost DESC LIMIT 3

[Sharif]

Which would you consider to be used to show the most POPULAR? Views or replies?

[rake]

I'd go for reply count.