Calendars [opinions needed]

Hey guys, looking for some advice.

I have a client who is in need of a dynamic calendar which of course they need to update. Doesn’t really matter if it’s php or asp.

Now…

I’n my head, I don’t see why storing the information in a database would be a problem. Just have all months and days in a database, make a layout which generates the database information accoring to date.

Have a CMS which you can update all this data, and I should be good to go right?

As far as database structure I was thinking of having each month be it’s own table, and of course have the day’s and events in the proper table.

Thing that concerns me most is leap year :sigh:

How will a leap year effect this?

Also as far as the SQL statement, I’m thinking of generate the data where month = current month. Is this wrong?

Basically I know it’s going to be a somewhat big project, but I also don’t think it’s too too hard to accomplish.

Any advice or suggestions would be great. if anyonehas done this before please let me know how you went about it.

I’m not looking for code or source files, although examples would be nice :slight_smile:

Thanks fellas,
Digital