--- a/myway/myway_timeliness_overview.php +++ b/myway/myway_timeliness_overview.php @@ -77,8 +77,7 @@ Stop 1 order by myway_stop"; + $query = "select myway_stop, avg(timing_delta), stddev(timing_delta), count(*) from myway_timingdeltas group by myway_stop having count(*) > 1 order by myway_stop"; $query = $conn->prepare($query); $query->execute(); if (!$query) { @@ -91,7 +90,7 @@ ?> Route 1 order by route_full_name"; + $query = "select route_name, avg(timing_delta), stddev(timing_delta), count(*) from myway_timingdeltas group by route_name having count(*) > 1 order by route_name"; $query = $conn->prepare($query); $query->execute(); if (!$query) {