time/date limit in query

[TECK]

Originally Posted by zurih

TECK, thanks for this useful info!
I really looked at the code and realized that 50% of it is not necessary.

Now I have to start looking at the codes of the hacks I've installed...
But in overall I really dont add any hacks that I really dont need for my board.

The code you gave me is works like a charm.
Really appreciate your help..
The query count is down by 1!
And I have to buy one of those books!

One thing though, I cant figure is out how to add the forumname of the thread to the info. All the things I tried gave me a Database error. You can see what I've tried in this thread...

Thanks again! :classic:

Heh, I told you to keep it simple... you don't listen to me, bad bad boy.
Use a simple query like this, if you really want to get everything from your thread:

$getthreads = $DB_site->query("
	SELECT forum.forumid, forum.title AS forumtitle, thread.threadid, thread.title, thread.lastposter, thread.lastpost, thread.postusername, thread.dateline
	FROM " . TABLE_PREFIX . "thread AS thread
	LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid)
	WHERE open = '1'
	AND thread.lastpost >= " . (time() - 86400) . "
	AND forumid NOT IN (0$limitfids)
	AND visible = '1'
	ORDER BY thread.lastpost DESC
	LIMIT 5
");

Then use this for your forum title:
$thread['forumtitle']

Have fun.