for($i = 0; $i < $row_count; $i++) { if($q[$i]["object_id"] != $current_host) { if($i != 0) { $host_times[$current_host]["total_time"] = time() - $first_time; $host_times[$current_host]["hostid"] = $current_host; } $last_state = $q[$i]["state"]; $last_time = $q[$i]["state_time"]; $first_time = $last_time; $current_host = $q[$i]["object_id"]; } else { switch ($last_state) { case 0: $state_name = "OK"; break; case 1: $state_name = "DOWN"; break; case 2: $state_name = "UNREACHABLE"; break; default: $state_name = "UNKNOWN"; break; } $host_times[$current_host][$state_name] = $q[$i]["state_time"] - $last_time; $last_state = $q[$i]["state"]; $last_time = $q[$i]["state_time"]; } echo "last state: ".$last_state." State Time: ".$last_time; } $host_times[$current_host]["total_time"] = time() - $first_time; $host_times[$current_host]["hostid"] = $current_host;