Displaying Records that are less than 30 days old.

[JSHINER]

I have records that are dated using date('y,m,d') when they are created.

 

Would like to only display records that are less than 30 days old. So, IF record is older than 30 days - do not display.

 

Here is my code:

 

$arr = $db->getArray("SELECT * FROM table WHERE id = '$id' ORDER BY date ASC");

[jitesh]

SELECT * FROM `tablename` WHERE (TO_DAYS(CURDATE()) - TO_DAYS(the feilds of ur table) <= 30)

[JSHINER]

Thanks !