Pretend you have a mysql calendar that looks like the following:
id - date - appointment_sta rt_time - appointment_end _time - title
1 - 2008-01-17 - 11:00 - 11:30 - Test
2 - 2008-01-17 - 11:30 - 14:00 - Test 2
3 - 2008-01-17 - 16:00 - 18:00 - And another Test bcuz I'm uncreative with titles.
How could you create a 24 hour daily calendar to show these dates? Similar to google daily calendar but not as advanced with the ajax. The calendar should start at 12:00am and work its way up in 30 minute increments and complete at 11:30pm, so from 12:00am to 12:30am to 1:00am etc, and when there's an appointment at one of the times, i.e. 11:00am to 11:30am, it should highlight those boxes with a different color and display the title.
If you were to put it into a table form, it would look like this with the html output
[HTML]
<table>
<tr><td>Time</td><td>Title</td></tr>
<tr><td>12:00am </td><td> - </td></tr>
......
<tr><td>11:00am </td><td>Appointm ent start: Test</td></tr>
<tr><td>11:30am </td><td>Appointm ent finish: Test Appointment Begin: Test 2</td></tr>
........
</table>
[/HTML]
Please help, i've tried doing this a few diff way's in php but just ended up making a mess.
id - date - appointment_sta rt_time - appointment_end _time - title
1 - 2008-01-17 - 11:00 - 11:30 - Test
2 - 2008-01-17 - 11:30 - 14:00 - Test 2
3 - 2008-01-17 - 16:00 - 18:00 - And another Test bcuz I'm uncreative with titles.
How could you create a 24 hour daily calendar to show these dates? Similar to google daily calendar but not as advanced with the ajax. The calendar should start at 12:00am and work its way up in 30 minute increments and complete at 11:30pm, so from 12:00am to 12:30am to 1:00am etc, and when there's an appointment at one of the times, i.e. 11:00am to 11:30am, it should highlight those boxes with a different color and display the title.
If you were to put it into a table form, it would look like this with the html output
[HTML]
<table>
<tr><td>Time</td><td>Title</td></tr>
<tr><td>12:00am </td><td> - </td></tr>
......
<tr><td>11:00am </td><td>Appointm ent start: Test</td></tr>
<tr><td>11:30am </td><td>Appointm ent finish: Test Appointment Begin: Test 2</td></tr>
........
</table>
[/HTML]
Please help, i've tried doing this a few diff way's in php but just ended up making a mess.
Comment