I am building a site that acts as some kind of calendar. I am struggling over finding a way to handle reccurent events, i.e. events that are noted as 'daily,' 'weekly', 'monthly', 'quarterly' and so on...
I've tried different approaches, but all end up being way to slow, or unmanageable. I'd like some hints about how I could handle that kind of things.
What'a a good approach to finding occurencies of a reccurent event, and how to manage exceptions on those ?
I am using MySQL and Zend php framework, and I am considering implementing Doctrine to globally help with the data management...
Any help on the matter would be appreciated, as the info I found on the subject is pretty thin.