I've been trying for the past few days to accomplish something that I finally deemed out of my league when it comes to programming.
I need to create/generate a graphical display that shows when and where a team needs to be at a certain time in a day.
My MYSQL Table returns the following information:
TEAM_ID | CLIENT / LOCATION | BEGIN HOUR | END HOUR | DAY |
1 | FOO | 8 | 11 | 2008-06-07 |
1 | BAR | 9 | 12 | 2008-06-07 |
2 | FOO | 10 | 13 | 2008-06-07 |
2 | JOE | 15 | 18 | 2008-06-07 |
3 | FOO | 18 | 20 | 2008-06-07 |
3 | JOE | 10 | 19 | 2008-06-07 |
4 | BAR | 8 | 14 | 2008-06-07 |
I can display this information easily, but my client needs it to be displayed graphically.
I've ran into some problems trying to do it by myself, mainly due to overlapping events (which are allowed to occur), therefore I wanted to ask anyone out there to see if they had a suggestion I could follow, a tutorial or some other type of help, anything would be greatly appreciated.
I've added a picture to illustrate the required output.