Need to add states, cities & specialties

[mikeymic]

I'm in the process of trying to add all 50 states, under those states I want at least 50 most populated cities and then I need to add specialty categories.

I am hoping to add a list of cities for each state to the database and set basic metadata fields that would call the wild cards like "Find a contractor in {$cityname}." for each city.

I'm sure someone has setup a site like this, but haven't seen one yet. Keep in mind I am no programmer.

If you want to see what I'm doing please check us out at http://www.AAA-Contractor.com. You can see that the amount of work is going to be overwhelming.

The reason I want to do this is that when people are searching for local contractors they need to find contractors first by state, then city, then specialty. Make sense? :smoke:

Thanks for any help that anyone provides!!!

Mike