Hey Jason,
With the records having a start_date and end_date, if I wanted to stop a record from showing on the website based on the end_date (lots of events are more than 1 day, so we want them to show for the entire period but still have the same sorting), how would I manipulate the query below? I've tried a few things, but can't get past the MySQL test in dreamweaver.
SELECT *
FROM events
WHERE DATE_FORMAT(sort_date, '%Y-%m-%d') >= Date_Format(Now(), '%Y-%m-%d') AND authorize = 1 ORDER BY sort_date ASC
Thanks!