[eluser]mabright[/eluser]
Hello,
I have been searching online like crazy trying to find a suitable database. I have a database table with all the US cities and states and even the state capital designation.
I also have a column that tells me whether a city is North, South, East or West of the state capital but I have not populated this column as I cannot find the data online.
I need to have a setup like craigslist where when you search for something, you can choose to search the capital city or the north side, east side, etc. I need to be able to group the cities in my table by area within the state.
Does anyone one know how I can obtain this data?
-mb