HowardMarks
MIS
Hi All
We run an events calendar on our website, which I am in the process of revising. It's based around the Arts so its full of things like exhibitions, plays, gallery opening etc. It's always a head scratcher to figure out how best to store and show the information for these events, especially when some of them span multiple days, weeks or even months.
I am just after some opinions or experiences on how best to go around structuring the database and search/retrieval methods for these kind of events. If an event lasts several days, should I use a seperate entry for each day that is is on, or should I be using start/end date for each event and programatically displaying that event on any days which fall inside that date range? One of the problems I find with this method is that some people may enter exhibition which spans several months, and therefore 'clutters up' the page for every single date within those months.
I don't expect anyone to provide a set-in-stone solution (and I doubt one exists anyway), but I would appreciate any thoughts/opinions on how you would approach this issue.
Many thanks for your time
Nick (Webmaster)
We run an events calendar on our website, which I am in the process of revising. It's based around the Arts so its full of things like exhibitions, plays, gallery opening etc. It's always a head scratcher to figure out how best to store and show the information for these events, especially when some of them span multiple days, weeks or even months.
I am just after some opinions or experiences on how best to go around structuring the database and search/retrieval methods for these kind of events. If an event lasts several days, should I use a seperate entry for each day that is is on, or should I be using start/end date for each event and programatically displaying that event on any days which fall inside that date range? One of the problems I find with this method is that some people may enter exhibition which spans several months, and therefore 'clutters up' the page for every single date within those months.
I don't expect anyone to provide a set-in-stone solution (and I doubt one exists anyway), but I would appreciate any thoughts/opinions on how you would approach this issue.
Many thanks for your time
Nick (Webmaster)