Creating online scheduler
Posted: Fri Nov 24, 2006 7:06 pm
Hi, I'm attempting to create an online scheduler. The current scheduler is actually just an Excel Spreadsheet. Each cell shows the start time and the end time of a task. The spreadsheet displays the schedule per week. I have a db already created on MySQL. Basically, what I would like is an idea on how to represent the schedule showing the start time and end time that is queried from the db. For example, I have one record with the following information:
date: 2006-11-01
press_start: 20:30
press_end: 22:30
How can I fill in several cells in a table to represent this task? The times on the schedule are in 15 minute blocks, that is, the day begins at midnight, then 12:15 AM, 12:30 AM, 1:45 AM, etc. Any ideas are welcome, I'm at a complete loss right now.
date: 2006-11-01
press_start: 20:30
press_end: 22:30
How can I fill in several cells in a table to represent this task? The times on the schedule are in 15 minute blocks, that is, the day begins at midnight, then 12:15 AM, 12:30 AM, 1:45 AM, etc. Any ideas are welcome, I'm at a complete loss right now.