I imagine this is an easy one for you all! I actually asked a very similar question probably 10 years ago, doesn't seem to be a way to find it in my history though :/ Thanks in advance for helping out a very, very casual coder.
I have a query that pulls events from my table. Events use `date` field if it is on a specific date, or the `date_from` and `date_to` fields if they occur over a range of dates.
SELECT * FROM cms_events WHERE county_id='7' AND status='1' and ((`date_to`>='2015-12-10' || `date`>='2015-12-10')) ORDER BY date_from,date,name ASC
Returned on the page, I would like to have a header separating events by date. So it would print "December 10", list results for 2015-12-10, then "December 11", list results for 2015-12-11, etc. Then at the end, "Ongoing" events, which are the ones using date_from and date_to fields.
Thank you for your help!
