My table contains a DATE Field that is time stamped and I want to query on anything that was added to the db in the last 30 days. What would be the proper mySQL syntax for that?
I tryed this but it didn't work.
$query ="SELECT * FROM table_name WHERE DATE<=(NOW()-30)";