Calendar and Repeating Events Ideas?

[gte806e]

I'm currently writing a calendar of events that will allow the user to add multiple dates to an event as well as setting the event to a repeating event (once year, day, month, twice a week, etc...)

I first came up with a model to store the record in one table, and then dates in another one entry for each date that would contain a parent id. So if you update the record. It would update for all event dates.

My problem is how to store this data if the event repeats indefinatly. How can I store this? Any reccomendations on how to do this?

Thanks,

Jesse

[renaun]

Check out PHPWebCalendar and disect the way the database is setup to handle the same kind of events.