Iım developing a calendar, with a view by month and list view, for a client and I would like to add the option for them to add an event and select if it is to repeat, i.e. Annually, monthly, weekly. As I see it now I can do one of two things (possibly more?). Add a predetermined amount of records in the database for each occurance or use a SELECT that can find a single event that has been marked to repeat and falls within the specified month or year.
The client will probably have less then 10 items per month. Here are my questions; Which option/direction would be better? Add records/do SELECT? Is there an example of a SELECT? Something like find records for July, 2003 and records marked repeat that would fall within the month of July, 2003. Any help appreciated, Tom
