mysql select

[testbot]

what is the lastpost in thread table format?

i need to select threads from the past 48 hours and where the lastpost is > 7 days

i'm not sure the best way to do this. i have the following so far.

$check=$vbulletin->db->query_read("
			SELECT * from `" . TABLE_PREFIX . "thread` 
			WHERE `forumid` IN($from)
			AND `lastpost` <= (TIMENOW - 7 DAYS)
			AND `dateline` <= (TIMENOW - 2 days)");

you can see the last two lines of the sql query need to be corrected.

thanks for your help!

[Lynne]

The lastpost and dateline are in unix time, so you want to convert your "7 days" and "2 days" into seconds.

[testbot]

i think i got it

i'll try

<= '" . (TIMENOW - ($days * 86400)) . "'

[Lynne]

That should work.