Interactiv map of the word

[badiou]

Hello !

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 !!!!

[papachan]

why you need a shared object? In your case you are just saving some preferences into a database, and show the user selection into an html.
For showing data in a swf, you can work it with XML or AMFPHP.

[badiou]

Hello,

Using a shared object seems to be a good idea to me, because I'll cut in several parts my map. When you select Europa or Asia, there'll be a dynamical loading (as sort as simplify the weight)...

So if I understood, you mean that I do not need a shared object but could either user a database to put user's preferences ?

[Jorge Solis]

SO means store data on client side, like a cookie. If you expect many sessions for a user could be a choice, If you expect to navigate in one session, then you just can keep the preferences in memory. If you need permanent data bout user choices available to others (or have more security about user data, since SO could be deleted or the user could browse your app from a different machine) then store to the DB

Jorge