I'm working on a world map. My idea is to associate it with a sql database containing all countries, states and areas. I've got several problems and that's why I turn to you.
First, I didn' find a complete database. I found some datas excessive and loud with unnecessary elements. I just want countries, states and areas, I do not need cities or latitudes.
After, I need your advices for the methodology. I thought to do an interactive map with flash. In function of the area desired, the user clicks on wanted zones, could stock it into a shared object and when he ended his visit, according to selection, he will be redirect to an HTML or dynamic page corresponding to their choices...
I thought to use XML associated with MySQL, but its doesn' seems appropriate with the shared object and I don't think we could generate a xml dynamically since MySQL.
What do you think of this case and which advices could you give me to take the good way ?
Many thanks !!!!