steelerman99 Posted July 12, 2008 Share Posted July 12, 2008 Hey all! I'm making a schedule for employees and in my web interface, i want to give them the option (when they're logged on) to select dates which they want to "Close" so I know not to schedule them on that particular day. I already have an employees table and a schedule table... I just want to create a table (or two) that employees can input their closed dates. Another question which may be just as important- what do you think would be the best way to implement this on a php web page? Meaning, how should the user enter their closed dates into the database? It would be nice to have some kind of point-and-click calendar to close dates, but i'm not sure how to do that. I appreciate you help!! Link to comment https://forums.phpfreaks.com/topic/114363-table-design-questions/ Share on other sites More sharing options...
Barand Posted July 12, 2008 Share Posted July 12, 2008 Create a "Closed" table ID | empID | closedDate and insert a row for each date closed by each employee Link to comment https://forums.phpfreaks.com/topic/114363-table-design-questions/#findComment-588519 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.