count hours

[sd1]

hello all!
i have a mySql dayabase where i store a date in a field called: addDate. the field type is datetime

i want my php scripts to check if the current date&time is 3 hours later then the date in the database.

how can i do that?

[nnichols]

SELECT *
FROM tblname
WHERE addDate < DATE_SUB(NOW(), INTERVAL 3 HOUR)

This should give you all entries where the current date/time is 3 hours or more later than the date/time in the db.

Or to check for all entries within the last 3 hours -

SELECT *
FROM tblname
WHERE addDate > DATE_SUB(NOW(), INTERVAL 3 HOUR)

Hope this helps