graphical day-time representation

[jared1874]

hi

I am writing a web application that uses php and javascript to interface with a database. I am trying to represent a number of different items of machinery that for many different reasons may or may not be functional during the course of a 12 hour day. I have all of the times and reasons for each machine stored in tables but I just want a graphical way to display the day to the user with colours representing working or not working, and it must be clickable on different sections to investigate deeper the reasons for the malfunction.

I began using an html form where a new column was created along one row for each 5 minute segment of time for 12 hours. (144 columns). I am sure (or hope) that there is a nicer and more better looking way to do this but am not sure at this stage.

If anyone has any ideas can you please let me know, thanks.
J

[frank grimes]

I think I understand what you're trying to do.

As you create the page, you'll have to query each item from your db and based on the info it finds, display a different graphic for working or not. I don't know what your data looks like or how a script could read it to determine the status, but it shouldn't be too difficult to display one graphic or another.

If you only need to drill down to see why it's _not_ working, you can dynamically create a link for the graphic tied to the field in the database:

<a href="www.xxx.c om/page.php?reason =5"><img src="broken.jpg "></a>

It's hard to be too specific without knowing more.

Hope this helps.

:grimey