The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 05-29-2008, 01:45 AM
trana's Avatar
trana trana is offline
Senior Member
 
Join Date: Sep 2005
Posts: 225
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default Select by lastpost?

I can't seem to get my SQL syntax right for a module.

$results = $db->query_read( "SELECT t.threadid, t.title, u.username, t.forumid, t.lastpost FROM " . TABLE_PREFIX . "thread t
INNER JOIN " . TABLE_PREFIX . "user u ON t.postuserid = u.userid
WHERE t.threadid IN (-1$ids) AND t.lastpost (what do I put here) ORDER BY t.lastpost DESC LIMIT 0,$limit");

I'd like to only select threads that have been updated in the last week (7 days). Can someone help me get the timestamp syntax right?

Thanks!
Reply With Quote
  #2  
Old 05-29-2008, 03:10 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Untested, but what do I put here =
> " . TIMENOW . " - (86400 * 7)
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Select Box Question Apocalypse Geek Article and Review System 5 05-31-2008 05:40 AM
Request - Select specific articles convergent Geek Gazette 1 05-31-2007 08:30 AM
Disabling GAB on select forum soultrader Geek Advertising Banner System 1 03-01-2007 09:32 AM
Possible to select different forms same forum? JohnBee Geek Article and Review System 0 11-24-2006 10:58 PM
checkboxes vs single select kidmercury Geek Advertising Banner System 1 08-31-2006 04:48 PM


All times are GMT. The time now is 11:13 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.