if ($c_res) { $result = pg_insert($dbconn, 'ap_history', $net_columns); $result = pg_insert($dbconn, 'ap_history', $c_res); $h_res = pg_query($dbconn, "SELECT * FROM ap_history WHERE bssid = '" . $net_columns['bssid'] . "' ORDER BY lastseen DESC"); $historyRows = array(); while($row = pg_fetch_assoc($h_res)) $historyRows[] = $row; $noTimeRows = $historyRows; for ($n = 0; $n < count($noTimeRows); $n++) $noTimeRows[$n]['lastseen'] = null; $result = pg_update($dbconn, 'ap_current', $historyRows[0], array('bssid' => $historyRows[0]['bssid'])); for ($n = 0; $n < count($noTimeRows); $n++) { if ($noTimeRows[$n] === $noTimeRows[$n +1]) { pg_delete($dbconn, 'ap_history', $historyRows[$n]); } } }