I'm developing a website that involves the display of a calendar of events.
A calendar that is able to view events for several days interval is what is desired.
My crude interpretation of these is having two fields each for:
The first three fields (dropdown) will serve as a start day, month, year while the second set of dropdowns will be for end dates (day, month, year), then when form is submitted, I check for matching values in the database and then display.
This method may slightly be inappropriate in a case whereby the difference between start and end dates are so huge. These events are meant for the homepage, thereby, it will be way too much to have huge amount of display for the homepage.
Another way I thought was, having three drop downs, for
Weeks: 1 - 5,
So, only the events for a week (7 days), in a particular month and year. But to achieve this effectively, it means there'll be a week’s column in the database table that will carry the week in which a particular day belongs...
The first option is a bit more dynamic, while the second is a bit strict and static, not to say it's a worse idea.
Could there be a simpler way to display these events, so that the user can only select a small (not necessarily just a week, but similarly small time period) range of dates to display?