Interesting challenge.
I tend to write TSQL more these days so this may not work on MySQL but the subquery
approach should give you an idea of the method. I just typed this up so it may not
even work! :-)
select min(stopped) as Stopped,Started, (Started-min(stopped)) as Duration from
(select
Hello,
I am relatively new to php, and have a question regarding polling a
mysql database and defining groups of data:
Say I have a table that looks like this:
Time| Speed
1016278580 | 0
1016278582 | 0
1016278584 | 0
1016278586 | 3
1016278588 | 7
1
