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
SELECT event_id, event_name, event_date
FROM events
where FROM_UNIXTIME(event_date) >= curdate() - interval 30 day
ORDER BY event_date ASC