I would like to create an online scheduling page for people to schedule meetings. Ideally this would display a calendar with the dates and times available, (which would be populated from a DB).
I don't have a problem with the scheduling after the calendar is created, the problem I cna't figure out is how to create a DB.
Right now I have a DB with a tables like such:
table months(yearID, monthID, monthName, firstDayOfMonth, totalDaysInMonth)
where firstDayOfMonth is the day of the week that the first day falls on.
for example, the query "SELECT * FROM months WHERE yearID=2002 and monthID=7" would yield:
2002, 7, July, 1, 31
Since 0=Sunday, 1=Monday and so on this tells me that July 2002 starts on a Monday and has 31 days, so from that I can construct a calendar.
Now, I know there is an easier way to construct a calendar, and I've looked for a perpetual calendar, but can't find any info on how to get the first day of the month based on any algorithm.
Does anybody have some ideas on an easier way ot accomplish this? Thanks