Menu
Hello,
I am making a forum and I would like to be able to give users info as to what the most popular threads are based on the number of posts in a thread. I cant figure out the query to find this. I have three tables: forums, threads, and posts. Each are linked by a foriegn key. The posts(messages) are stored in the posts table with a thread_id as the foriegn key. Any help on coming up with a query that I could limit to the top 5 would be very helpful.