codepad
[
create a new paste
]
login
|
about
Language:
C
C++
D
Haskell
Lua
OCaml
PHP
Perl
Plain Text
Python
Ruby
Scheme
Tcl
<?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); } ?>
Private
[
?
]
Run code
Submit