Query to get threads ?

[Imran]

Hi Zinga

I ran this query

PHP Code:

$query = $db->query(" SELECT tid , subject FROM " .TABLE_PREFIX. threads." ORDER BY tid DESC LIMIT 5");

---

This gives me 5 threads from complete all forums in descending order.
But the question is I want to get threads from thread's forum where thread is.. and count and show them on showthread page.

I hooked to showthread_end. Help please Zinga