Query to get threads ?
Imran Offline
Member
***
Posts: 204
Joined: Apr 2010
Post: #1
At Query to get threads ?
Hi Zinga Smile

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 Frown


[Image: logo.png]

[Image: twitter.png]
08-18-2010 07:02 AM
Visit this user's website Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
Query to get threads ? - Imran - 08-18-2010 07:02 AM
RE: Query to get threads ? - ZiNgA BuRgA - 08-18-2010, 07:36 AM
RE: Query to get threads ? - Imran - 08-18-2010, 04:42 PM
RE: Query to get threads ? - ZiNgA BuRgA - 08-18-2010, 07:38 PM
RE: Query to get threads ? - Imran - 08-18-2010, 09:53 PM
RE: Query to get threads ? - FBI - 08-21-2010, 08:36 PM
RE: Query to get threads ? - Imran - 08-21-2010, 09:01 PM
RE: Query to get threads ? - ZiNgA BuRgA - 08-21-2010, 10:13 PM
RE: Query to get threads ? - FBI - 08-22-2010, 01:06 AM
RE: Query to get threads ? - ZiNgA BuRgA - 08-22-2010, 08:44 AM
RE: Query to get threads ? - FBI - 08-22-2010, 06:19 PM
RE: Query to get threads ? - ZiNgA BuRgA - 08-22-2010, 09:54 PM

 Standard Tools
Forum Jump: