Question about DATE

[izbryte]

I have a page where people can make postings but I only want them to be viewable for 30 days. I'm putting it into the database with the NOW() function. When I bring it back out how do I check to make sure the posting hasn't expired?

[pocobueno1388]

Only select the ones that haven't expired, like this:

 

SELECT * FROM postings WHERE post_date < (NOW() - INTERVAL 30 DAY)