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:238276
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
