[truesilentassassin]

Hello Experts,

I do have another thread in this forum with the same situation. But I really need help here.

This is what I want:

I am trying to do something that I am pretty sure has been done before. May be some of you might have done this.

I want to develop a page in php which has the US Map with all 51 states clickable. When the states are clicked, all the major cities in that state should be displayed in alphabetical order and when cities are clicked, I want some information about the city.

I have developed this in php and it is working fine. However, I have 51 php files for all the state and 100's or pages for cities. I have this because I don't know how to do it with just 1 php page for states and 1 php file for cities.

I have all the 51 states in my MYSQL database and about 300 major cities in my database as well.

Can anyone please help me with a couple of php scripts that will do this. All I want is a US Map in one page which when clicked on a state will lead to another php page that lists all the cities based on the state clicked.

Thanks in advance.

Appreciate your help.

Regards,