Hi there

I have a datetime field taken from a SQL table

I want to check if the date is older than 3 months from today given that i have set a php variable to = the datetime value

$datetocheck = $row['datetime']

I want to work with $datetocheck

any help would be appreciated.

Thanks

Steve

PHP Code:

if (strtotime($datetocheck) > strtotime("+3 months"))
{
    // Is greater than 3 months from now
} 


Depending on what your purpose is, it might be easier/better to make the comparison in your SQL query instead, when retreiving the data. As in

SELECT a,b,c,my_time
FROM table
WHERE my_time < DATE_SUB(now(), INTERVAL 3 MONTH)