$day = strtotime("-1 month 00:00:00"); echo date("Y-m-d H:i:s",$day); echo "<hr />";
$day1 = strtotime("-1 month -1 day 00:00:00"); echo date("Y-m-d H:i:s",$day1); echo "<hr />";
SELECT FROM_UNIXTIME(inputtime,'%Y-%m-%d %H:%i:%s') FROM tablename WHERE
FROM_UNIXTIME(inputtime,'%Y-%m-%d') <= '2014-10-08'
AND FROM_UNIXTIME(inputtime,'%Y-%m-%d') >= '2014-10-07';
$day = strtotime("-1 month 00:00:00"); echo da