php - Datetime and date-range comparsion -

i have datetime-row in mysql database. have check time between , date using php. if range bigger 1 month - somtething.

i tried this:

$datefrommysql = strtotime($rowdata); $currentdate = date("m/d/y g:i a");

and comparsion hands. it's ugly.

select  *    mytable   mydatetime <= now() - interval 1 month         or mydatetime >= now() + interval 1 month

this query returns dates @ least 1 month apart now() (either in past or in future).

Manage