This lightweight plugin makes it easy to install the millions of GEONAMES Data on your WordPress site..
Choose type of data to install.
Upload the folder and its contents into the wp-content plugins directory of your WordPress installation.
Select Columns you want to insert.
Name of the table geonames.
SELECT name, FROM..$wpdb->prefix. geonames WHERE country code='CH and feature class='P ORDER BY DESC LIMIT 10 ) foreach { echo $t->name... $t->population... }.
SELECT latitude, FROM..$wpdb->prefix. geonames WHERE name=' Marbella and country code=' ES ) $dlat = 40 1.852 60 $dlon = 40 1.852 60 cos $s = $wpdb->get results (.
SELECT name, latitude, FROM..$wpdb->prefix. geonames WHERE country code=' ES and feature code='HTL and latitude<. . and latitude>. . and longitude<. . and longitude>. ..
LIMIT 100 ) foreach { $d = *60*1.852,2 ) +pow *60*1.852*cos,2 ) ) ) ) if echo $t->name... $d. km. }.
Browse the code, check out SVN repository, or subscribe to the development log by RSS...
Read more