Gradovi (Srbija) SQL Ready

[webarto]

PHP kôd:

//Beograd
$grad = mysql_query("SELECT * FROM srbija WHERE grad = 'Beograd' LIMIT 1");
$grad = mysql_fetch_assoc($grad);
$lat = $grad["lat"]; $lon = $grad["lon"];

$radius = 10; // 10 kilometara
$radius = round($radius / 111, 7); // 1 stepen = 60 nautičkih milja ~ 111km, zemlja nije krug ali je razlika 0.3%

$sql = mysql_query("SELECT * FROM srbija WHERE lat BETWEEN ($lat - $radius) AND ($lat + $radius) AND lon BETWEEN ($lon - $radius) AND ($lon + $radius)");
while($red = mysql_fetch_assoc($sql)){
    echo $grad["grad"]." - ".$red["grad"]." = ".haversine($lat, $lon, $red["lat"], $red["lon"])."<br />";
} 


Beograd - Alt-Borscha = 5.79316506111
Beograd - Bárányos = 9.35219525075
Beograd - Belgrad = 0
Beograd - Belgrade = 0
Beograd - Belgrado = 0
Beograd - Beograd = 0
Beograd - Bezanija = 7.20118432749
Beograd - Borca = 5.79316506111
Beograd - Borcsa = 5.79316506111
Beograd - Bubanj Potok = 11.085803226
Beograd - Cukarica = 5.50759465291
Beograd - Dorcol = 0.242342119582
Beograd - Filmski Grad = 7.29055150674
Beograd - Gisellenhain = 9.35219525075
Beograd - Jajince = 8.8637130281
Beograd - Jajinci = 8.8637130281
Beograd - Kaluderica = 10.0123750758
Beograd - Kaludirica = 10.0123750758
Beograd - Kalugjerica = 10.0123750758
Beograd - Karaburma = 2.66566666921
Beograd - Kumodraz = 9.39940017819
Beograd - Mala Ciganti = 4.38736003825
Beograd - Mali Mokri Lug = 7.03790686951
Beograd - Mokri Lug = 8.23222134719
Beograd - Novi Beograd = 3.75416324228
Beograd - Ovca = 9.35219525075
Beograd - Ovcsa = 9.35219525075
Beograd - Reva = 5.46912292882
Beograd - Rospi Cuprija = 4.62338905561
Beograd - Sajmiste = 1.93995055969
Beograd - Savski Venac = 4.52617380096
Beograd - Semlin = 5.93785726157
Beograd - Singidunum = 0
Beograd - Stara Borca = 5.79316506111
Beograd - Stari Grad = 1.68389610582
Beograd - Taurunum = 5.93785726157
Beograd - Tosin Bunar = 5.03993677578
Beograd - Veliki Mokri Lug = 8.23222134719
Beograd - Vojna Basta = 9.27635855118
Beograd - Vozdivac = 4.52055022048
Beograd - Vozdovac = 4.52055022048
Beograd - Vracar = 3.96300110998
Beograd - Zarkovo = 7.83593874715
Beograd - Zeleznicka Kolonja = 6.9968568556
Beograd - Zemlén = 5.93785726157
Beograd - Zemun = 5.93785726157
Beograd - Zimony = 5.93785726157
Beograd - Zvezdara = 5.76970836174

Novi Sad

Novi Sad - Kamanc = 3.18673675777
Novi Sad - Kamancz = 3.18673675777
Novi Sad - Kamenicz = 3.18673675777
Novi Sad - Kamenitz = 3.18673675777
Novi Sad - Kamonc = 3.18673675777
Novi Sad - Neoplanta = 0
Novi Sad - Neusatz = 0
Novi Sad - Novi Ledinci = 5.23735837334
Novi Sad - Novi Rakovac = 7.48661578121
Novi Sad - Novi Sad = 0
Novi Sad - Nový Sad = 0
Novi Sad - Ó-péterváradja = 0
Novi Sad - Pasuljiste = 4.70016657699
Novi Sad - Pétervárad = 3.37320414099
Novi Sad - Peterwardein = 3.37320414099
Novi Sad - Petrovaradin = 3.37320414099
Novi Sad - Sremska Kamenica = 3.18673675777
Novi Sad - Újvidék = 0
Novi Sad - Varadinum Petri = 0
Novi Sad - Vásáros-Várad = 0
Novi Sad - Veternik = 6.06948254759

Izvinjavam se na dužem postu