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
//********************************
?>
//***************** 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
//********************************
?>
Comments
Post a Comment