I'm given the task to create a calendar on our club site - I will probably be using FullCalendar (http://arshaw.com/fullcalendar/
) and for sure php/mysql as backend.
But I'm not sure how to save repeating events in the db, so I'm looking for input and articles on that issue.
Eg. A user creates an event "Clean refrigiator" that should repeat every weekday at 7:30
Instead of creating 365 events * N years - how should I store these events in the mysql db so it's quick to retrieve them again ?
Any input is appreciated.