I have a events table and each event has a date, the date that is stored in the table is a php time() stamp. I need to list the events but I only want to list the events from the last 30 days.
This is the current SQL query I have
SELECT event_id, event_name, event_date
FROM events
where e.event_date <= 'time()'
ORDER BY event_date ASC