Simple Date Query From MYSQL

[ankycooper]

hi ???

I Have a table named prop_tbl with a lot of feilds, one of the feilds is create_date which stores the timestamp of the record creation.

 

Now i want to pull up the records which are x months old.

 

 

please help

 

$months=10;
$nowstamp=time();
$expirestamp=strtotime("-$months month",$nowstamp);

"SELECT * FROM prop_tbl WHERE create_date<='$expirestamp'"

 

but it simply thows all the records

 

 

Please help I just want records whose create_date is greater than  equal to $months

[eludlow]

Do you want to show all the records that are OLDER than 10 months?

 

If so then I'd have thought:

 

$tenMonthOldTimestamp = time() - 24192000; (number of seconds in ten months..)

 

then

 

mysql_query("SELECT * FROM `prop_tbl` WHERE create_data <= '

$tenMonthOldTimestamp'");

 

E

[ankycooper]

Hey Thanks for replying...

But How did you get the number.....24192000.

 

i want to pull up $months intervals....

 

$months can be 10 Months or 1 Month Or 12 Months ... I mean Anything

 

 

Looking Forward For help

[The Little Guy]

The date column needs to be in a timestamp format.

 

$months = 5;

$sql = mysql_query("SELECT * FROM users WHERE `date` < DATE_SUB(NOW(),INTERVAL $months MONTH) AND 
`date` > DATE_SUB(NOW(),INTERVAL ".($months + 1)." MONTH)");