Dates not sorting properly...
Jason,
You helped me sort this data before and it was working perfectly on the home page, as well as the events page. Here is the SQL Statement:
SELECT *
FROM events
WHERE DATE_FORMAT(sort_date, '%Y-%m-%d') >= Date_Format(Now(), '%Y-%m-%d') AND authorize = 1
Not sure if it is the data that is not entered properly on these few events on the home page, but it is out of order. On the events page, it is perfect. Not sure why.
See PM