select records added 30 days ago

[blackhorse]

In the past, what I do is using the php to get the 30 days ago date

$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"), date("Y"));
$lastmonth_date=date("Y-m-d", $lastmonth);

And then compare this $lastmonth_date with the date_added field (datetime type).

how to not using php to get 30 days ago date first, just ask the mysql to do this 30 days ago sql select with mysql built in features?

And which approach you prefer?

Thanks!

[NogDog]

You can use the various "date arithmetic" functions available in the MySQL date and time functions. For instance, if you want the date 30 days ago:

DATE_SUB(NOW(), INTERVAL 30 DAY)