Display Popular Threads on my PHP Website

[filburt1]

Depends on how you define popular. If you mean number of views:
[sql]
SELECT title, threadid, views FROM thread ORDER BY views DESC LIMIT 10;
[/sql]
Or number of replies:
[sql]
SELECT title, threadid, replycount FROM thread ORDER BY replycount DESC LIMIT 10;
[/sql]