[RESOLVED] Find last X days of posts with timestamp

[esiason14]

I want to find the last 10 days worth of posts...i'm having a probably doing so with the time stamp:

$sql = "SELECT p.*, pt.*, f.*
	FROM phpbb_posts p, phpbb_posts_text pt, phpbb_forums f
	WHERE pt.post_text LIKE '%$fname $lname%'						
	AND pt.post_id = p.post_id
	AND f.forum_id = p.forum_id
	AND f.forum_id = '88'
	AND p.post_time >= date_format(date_add(CURRENT_TIMESTAMP(), interval 14 day),'%Y%m%d000000')
	ORDER BY p.post_time DESC
    LIMIT 0,1";

that's probably way off, but hopefully you get the idea of what i'm trying to do...any help would be appreciated..thanks!

[esiason14]

This seems to work:

$sql = "SELECT p., pt., f.*
FROM phpbb_posts p, phpbb_posts_text pt, phpbb_forums f
WHERE pt.post_text LIKE '%$fname $lname%'
AND pt.post_id = p.post_id
AND f.forum_id = p.forum_id
AND f.forum_id = '88'
AND DATE_SUB(CURDATE(),INTERVAL 14 DAY) <= DATE(FROM_UNIXTIME(p.post_time))
ORDER BY p.post_time DESC
LIMIT 0,1";

[bradgrafelman]

Incidentally, this same type of time-based query appears in the first query example on the MySQL manual page for Date and Time Functions.

Don't forget to mark this thread resolved (if it is).

[esiason14]

Doh...oh well. I did get it resolved