\n";
$query = "SELECT DISTINCT ddmmyy FROM gps_input WHERE lat_ddmm IS NOT NULL AND lon_ddmm IS NOT NULL";
mysql_connect("localhost", "eastmil5_eastmil", "its2secret") or die("Unable to connect to SQL server because" . mysql_error());
mysql_select_db("eastmil5_auto") or die("Unable to select database");
$result = mysql_query($query) or die("Insert Failed!" . mysql_error());
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$date = mysql_result($result,$i,"ddmmyy");
echo "" . substr($date,2,2) . "/" . substr($date,0,2) . "/" . substr($date,4,2) . " \n";
$i++;
}
echo "