// Chemin et nom du fichier texte
  $filename = "fichiersgeoindex/villesdeplusde100000habitants.txt";
  // Ouvre le fichier en mode ecriture
  $handle = fopen($filename, "a");
 
  // Requete MySQL pour récupérer les informations d'une table
  $SQLcity = "SELECT * FROM city WHERE city_population>100000 GROUP BY city_name";
  $Rscity = mysql_query($SQLcity,$dblink);
  while ($valcity=@mysql_fetch_array($Rscity)) {
    $citypostalcode = $valcity["city_postalcode"];
    $cityurl = $valcity["city_url"];
    $cityname = $valcity["city_name"];
    $citypopulation = $valcity["city_population"];
    // Ecriture de la ligne d'informations
    fwrite($handle, $citypostalcode.";".$cityurl.";1;".$cityname." : ".$citypopulation." hab;1\n");
  }
  // Fermeture du fichier texte
  fclose($handle);