What RDBMS? In Oracle you can do something like this:
SELECT extract(month from startdate) as event_month, extract(day from startdate) as event_day, event_title FROM events WHERE active=1 ORDER BY startdate ASC -----Original Message----- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
