[Resolved] Results 30 days or newer

[sgtpepper]

I am trying to get the results from a database that are 30 days or newer....here is what I have so far. I am not sure how to go about this....but here is what I have tried. Obviously, this doesnt address the 30 day issue......I am getting a syntax error.

Can you give me an idea of what I need to do?

$date_time = date('Y-m-d G:i:s');
$query2="SELECT mod_date_time from mastertable WHERE mod_date_time < '$date_time'";

[barand]

Try

$date_time = date('Y-m-d', strtotime("-30 days")); 
$query2="SELECT mod_date_time from mastertable WHERE mod_date_time > '$date_time'";

hth