Seeing if a DATETIME value is over 24 hours ago?

[ndm250]

I need a if statement that checks to see if a datetime value is >= 24 hours ago.

Here's what I need it for: if a user clicks a button the datetime would be updated in the database for that user. Only 24 hours after may that same user click that button again.

Any suggestions?

[Chris Hick]

Pull out of your database the time stamp and place it in a variable such as $date_time and use the code below.

$flexibility = 86400; // 60 * 60 * 24 to get 86400 seconds which is 24 hours.
if ($date_time < time() - $flexibility )
{ echo "You must wait 24 hours before pressing this button."; } 

[kbluhm]

This can be done entirely in MySQL using DATE_SUB():

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

SELECT *
FROM `user`
WHERE DATE_SUB( NOW(), INTERVAL 1 DAY ) >= `user_lastClick`

Using this query, only those users who are allowed to re-click will be selected.

Untested, but should work.