<?php
    $query = mysqli_query("SELECT time, lat, `long` FROM Points ORDER BY time");
    
    // output header row
    echo str_pad('time', 8) .'|';
    echo str_pad('lat', 7) .'|';
    echo "long\n";
    
    $prevLat = $prevLong = '';
    while ($row = mysqli_fetch_assoc($query)) {
        if ($row['lat'] === $prevLat && $row['long'] === $prevLong) {
            // if this row's lat and long values are the same as the previous row's values, skip this row.
            continue;
        }
        
        $prevLat    = $row['lat'];
        $prevLong    = $row['long'];
        
        echo str_pad($row['time'], 8) .'|';
        echo str_pad($row['lat'], 7) .'|';
        echo "{$row['long']}\n";
    }
    
	
	
	
	
	
	
    /********************************************/
    /*  STOP HERE, DON'T CREATE THESE FUNCTIONS */
    /*  This is just for use on codepad         */
    /********************************************/
    function mysqli_query($string) {
        return array(
            array('time' => '113', 'lat' => 2.1, 'long' => 5.8),
            array('time' => '114', 'lat' => 2.1, 'long' => 5.6),
            array('time' => '115', 'lat' => 2.1, 'long' => 5.6),
            array('time' => '116', 'lat' => 2.1, 'long' => 5.6),
            array('time' => '117', 'lat' => 2.1, 'long' => 5.6),
            array('time' => '118', 'lat' => 2.3, 'long' => 5.2),
            array('time' => '119', 'lat' => 2.4, 'long' => 5.3),
            array('time' => '120', 'lat' => 2.5, 'long' => 5.3),
            array('time' => '121', 'lat' => 2.5, 'long' => 5.3),
            array('time' => '122', 'lat' => 2.6, 'long' => 5.3),
            array('time' => '123', 'lat' => 2.1, 'long' => 5.6),
            array('time' => '201', 'lat' => 2.1, 'long' => 5.6),
            array('time' => '202', 'lat' => 2.1, 'long' => 5.6),
            array('time' => '203', 'lat' => 2.5, 'long' => 5.3)
        );
    }
    
    function mysqli_fetch_assoc(&$array) {
        return array_shift($array);
    }
?>

time    |lat    |long
113     |2.1    |5.8
114     |2.1    |5.6
118     |2.3    |5.2
119     |2.4    |5.3
120     |2.5    |5.3
122     |2.6    |5.3
123     |2.1    |5.6
203     |2.5    |5.3