<?php
  date_default_timezone_set("UTC");

  $mysqlConnection = mysql_connect("server","db","pwd");

  if (!$mysqlConnection)
    {
      die("Could not connect: " . mysql_error());
    }

  mysql_set_charset("utf8");

  mysql_select_db("db");

mysql_query("DELETE FROM geonames");

  // Get a file into an array.
  $lines = file("http://download.geonames.org/export/dump/modifications-" . date("Y-m-d", time() - 86400) . ".txt", FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);

  // Loop through our array.
  foreach ($lines as $line_num => $line)
    {
      $lineData = explode("\t", $line);
print 'INSERT INTO geonames VALUES ("' . $lineData[0] . '", "' . $lineData[1] . '", "' . $lineData[2] . '", "' . $lineData[3] . '", "' . $lineData[4] . '", "' . $lineData[5] . '", "' . $lineData[6] . '", "' . $lineData[7] . '", "' . $lineData[8] . '", "' . $lineData[9] . '", "' . $lineData[10] . '", "' . $lineData[11] . '", "' . $lineData[12] . '", "' . $lineData[13] . '", "' . $lineData[14] . '", "' . $lineData[15] . '", "' . $lineData[16] . '", "' . $lineData[17] . '", "' . $lineData[18] . '")' . "<br />";
      mysql_query('INSERT INTO geonames VALUES ("' . $lineData[0] . '", "' . $lineData[1] . '", "' . $lineData[2] . '", "' . $lineData[3] . '", "' . $lineData[4] . '", "' . $lineData[5] . '", "' . $lineData[6] . '", "' . $lineData[7] . '", "' . $lineData[8] . '", "' . $lineData[9] . '", "' . $lineData[10] . '", "' . $lineData[11] . '", "' . $lineData[12] . '", "' . $lineData[13] . '", "' . $lineData[14] . '", "' . $lineData[15] . '", "' . $lineData[16] . '", "' . $lineData[17] . '", "' . $lineData[18] . '")');
    }

  mysql_close($mysqlConnection);
?>