/    Sign up×
Community /Pin to ProfileBookmark

all cities names

can any one help me ……

i want all cities names for all countries to my site like…. (the user select his country from combobox then get the cities of his country)

to post a comment
JavaScript

8 Comments(s)

Copy linkTweet thisAlerts:
@KorApr 27.2006 — the problem is quite easy, as code, but the main problem is: "[B]all[/B] the cities for [B]all [/B]the countries". As you might need to work with an array, the array would be huge, hard to load and handle... A data base and a server-side application would suit better to this kinda job. Or maybe on using AJAX to load only the cites of a coutry on each request.
Copy linkTweet thisAlerts:
@I_m_IauthorApr 27.2006 — thanks for your fast replay

but i don't need the code all i need is all cities names in database (excel ,access,etc..) to add to my site using mysql
Copy linkTweet thisAlerts:
@KorApr 27.2006 — As I said, there will be a bad ideea to add all the cities somehow on the page from the begining. You should use php, for instance, to grab from the DB only the cities of a certain country using a submit and onchange event in the countries list box.
Copy linkTweet thisAlerts:
@I_m_IauthorApr 27.2006 — thanks KOR

i agree with u and i will make it but i need an exit database of all cities group by country

i can get all cities name from the web but i still have to put all this in database so i need an exit database
Copy linkTweet thisAlerts:
@I_m_IauthorApr 27.2006 — like the one in hotmail i can select my country and then select my city

i can not get all countries and all cities and insert them in my database it take loooooooooong time from me

all I need is an exit work in any type(excel,access,mysql,ect...) are there ?
Copy linkTweet thisAlerts:
@KorApr 27.2006 — aha, I got it... I don't know about such an exhaustive list. Try google for.
Copy linkTweet thisAlerts:
@I_m_IauthorApr 27.2006 — thanks KOR

i found it but it very large database

here is the link

http://earth-info.nga.mil/gns/html/geonames_dd_dms_date_20060410.zip

and here is anther site u can select any country

http://en.wikipedia.org/wiki/List_of_city_listings_by_country
Copy linkTweet thisAlerts:
@Khaleel_AsrafAug 17.2006 — Hi,

You could check this site: http://www.geodatasource.com

Hope that helps.

Khaleel
×

Success!

Help @I_m_I spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.20,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...