Timestamp help please

[chris_stfc]

Hello,

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

$database_timestamp = $row['database_timestamp']; 

and I have a current timestamp

$current_timestamp = ('Y-m-d H:i:s', strtotime('now')); //Now 

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.

Just can't get my head around it

[Dan Grossman]

Work with them as timestamps (number of seconds since January 1, 1970) rather than formatted strings, then it's just arithmetic.

$database_timestamp = strtotime($row['database_timestamp']);
$minutes_difference = (time() - $database_timestamp) / 60; 

But really you should just do it in your database query.

SELECT ... WHERE database_timestamp < DATE_SUB(CURRENT_TIMESTAMP, interval 10 minute)