Web Site SEO Now

mysql php url help generate a url from a form?

with a database of cities and states is it possible to use the GET method to connect to the database, have the user submit the desired city and state in a form and be redirected to that specific page by having the database return a url?
If not the get method then how, I am lost on this one, any help would be great! P.S. I want a SEO friendly url. such as www.whatever.com/Atlanta/GA

You could use the GET method and the use mod_rewrite to rewrite your URLs to something more SEO friendly.

For example:

www.whatever.com/?city=1&state=2

rewrite that to www.whatever.com/Atlanta/GA

Where city 1 is equal to Atlanta, and state 2 is equal to GA

Atlanta Web Entrepreneurs – SEO Workshop