MySQL sorting question

[Rohan_Hill]

I have this MySQL question:

Say I'm making a forum script, and have a table containing all the threads, and each thread has an id.

Then I have another table, containing all the reply posts, and each reply contains the id of the thread the reply is to.

Is there some MySQL code I can use when retrieving the threads, to sort them by the number of replies they have? Thanks!

[bogu]

Try ORDER BY function from mysql.

[nnichols]

SELECT *, COUNT(p.post_id) AS num_replies
FROM threads t
LEFT JOIN posts p
ON p.thread_id=t.thread_id
GROUP BY t.thread_id
ORDER BY num_replies

Hope this helps 😉

[Rohan_Hill]

Cool, thanks, I'll give that a try 🙂