I'm not 100% clear exactly what you're trying to achieve but do you really need to SELECT DISTINCT rather than plain old SELECT?
It sounds like you're wanting to get all of the entries for a particular month but grouped together according to their associated day. You can either bring them all back, and use PHP to 'group' by the day or you can only select one from each day (DISTINCT event_date).
|