I'm trying to get my head around comparing two dates in a MYSQL query.
Say I have a timestamp called out of a database
and I have a current timestampPHP Code:
$database_timestamp = $row['database_timestamp'];
How can I write a query to say if the $database_timestamp is last 10 minutes elapsed of the $current_timestamp then don't do something, else do do it.PHP Code:
$current_timestamp = ('Y-m-d H:i:s', strtotime('now')); //Now
Just can't get my head around it