Get Next Month Data in PHP
<?php //***************** Query ************ $query = "select * from test_table where date < date_sub(now(), interval 1 month)" ; $res_query = mysql_query($query); //*********** OUTPUT ************ int_id name date 1 Sandy 04-06-2015 2 Vandy 11-06-2015 3 Andy 18-06-2015 //******************************** ?>