0

Howdy.

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.

Attachments schedule.gif 6.27 KB
1
Contributor
1
Reply
2
Views
9 Years
Discussion Span
Last Post by Rohlan
0

I have found a solution to my problem. Please ignore.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.