The last 24 hours

[Anon]

I have a forum in which I need to run a query only on posts within the last 24 hours. Each post has a date field associated with it that is stored as a datetime in a mySQL db. So it needs to be "SELECT * FROM forum WHERE (date <= 24 hours)" with the () obviously filled in. Any help would be appreciated. TIA.

[Anon]

where unix_timestamp(datetime) <= 86400

[Anon]

Or...

SELECT * FROM forum WHERE date <= NOW() - INTERVAL 24 HOUR;

+/- Interval works in 3.23

You have to use date_add, date_sub in 3.22...

This is an easier way to do it, easier to understand, too. You can set a variable $hours, and have it equal to 24, 48, 72, etc..depending how much data you want to select out..then use:

SELECT * FROM forum WHERE date <= NOW() - INTERVAL $hour HOUR;

---John Holmes...