Ok, I have a form for new user to fill out to get an account. When they fill it out there is the normal things like User Name, Password, etc. the stumper is the Location. I have a code set up for the DB, for example:
AL00 - Alabama
AK00 - Alaska
AZ01 - Arizona, Tucson
AZ02 - Arizona, Phoenix
AZ00 - Arizona, Other Areas
AR00 - Arkansas
CA01 - California, Los Angeles Area
CA02 - California, Orange County
CA03 - California, Sacramento
CA04 - California, San Diego
CA05 - California, San Francisco Bay Area
CA00 - California, Other Areas
CO00 - Colorado
CT00 - Connecticut
When the user click submit it brings them to the next page and show all the information they entered and a welcome message. But when I print the location it prints as AL00 for Alabama. I know I can nest if statements for that if location = AL00 print Alabama. But is there a better way. My location list is world wide and that will be a lot of code if I nest it. Any ideas, suggestions, or pointers out there.
Thank you for the help in advance.