MySQL common data -- where to find them?

[ipruthi]

Hello everyone.

Been a long time since I came on these forums.

I'm building an travel agency application and I need to populate my countries, cities, states, and airport codes with data.

Is there a place where this data is available? Any of it? I came across another thread that referenced a page that had Digital Data but couldn't use any.

Thanks in advance.

I.

[AstroTeg]

This kind of data usually has to be purchased if you want it formatted nicely and ready for import into a database. Otherwise, if you search hard and long enough, you'll find it on the web in HTML form (mostlikely) and you could build a script to parse the data and import it in that way.

[ipruthi]

Yea, I had to reformat it.

However, the one I found was:

http://dbis.informatik.uni-goettingen.de/Mondial/#Oracle

The Mondial database.

Hope it helps anyone.

I.