|
Hi All
I am pretty new at using PHP and MySql so if this seems like a very basic question please don't point and laugh.
He is the deal I have a MySql database that I need to get my data from and what I need to do is using php and Mysql
the MySql table is called eventlog using the name, text ,and time columns I need to get and figure the time it took for a scan to run. In the time column I have the start time and the finish time these are different rows in the database. The format is HH:MM:SS. From the text column I can see when a scan starts and stops. So my idea is to some how look at the finish time and subtract it from the start time and get total time it took.
Now using the same info I would like to be able to take all scans for 1 machine and then figure how what the average time for scans is per machine.
thanks in advance for any help offered
This post has been edited by bucknakie: 25 Mar, 2005 - 09:04 PM
|
25 Mar, 2005 - 09:03 PM
| 