Hottest Threads!
 

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.

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

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

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

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?

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

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.

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.

The three with the most replies:

[sql]SELECT * FROM thread ORDER BY replycount DESC LIMIT 3[/sql]

The three with the most views:

[sql]SELECT * FROM thread ORDER BY views DESC LIMIT 3[/sql]

The three latest updated threads:

[sql]SELECT * FROM thread ORDER BY lastpost DESC LIMIT 3[/sql]

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