Hey, In attempt to help you out: > So I need a table with every date in it??? (hope not!) > Are Any suggestions how to implement this? Only store the date that is flagged as busy in a table, that way every other day will be considered free - use PHP to generate the rest of the days on the fly and then fill in the calendar.
> My first thought would be to give each employee their own entry in an > emplyee table. Then just create a new table with simply date - > Employee Id This is a good way to go - in my opinion it is the best way to go about it [as well as the easiest / less database activity intense] PHP has built in functions for determining the day of week and everything so you can easily create a dynamic calendar generation system [you might have to hard code leap years and odd months like February etc] HTH charles ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
