i have a mysql database with thousands of records--one record every 10 seconds. each record measures, among other things, amperage readings from a piece of equipment. When the equipment is on, the amperage reading is greater than one. When the equipment is off, the amperage reading is less than one. i need to loop through the data and count the number of times the equipment turns off.
Hello, I am experienced PHP/SQL developer. The task you want requires custom PHP code to be developed, which will loop through the SQL table and filter data. I can write you simple, well commented function, that will surely suit your needs.
Definitely know my way around MySQL/SQL in general as well as working with data from certain machinery and systems...
I can give you something very nice and something you can use later down the road as well.