Page 1 of 1

Drop down menu for all 50 states available?

Posted: Wed Apr 06, 2005 12:24 am
by Fusioned
Anyone know of a good place I can go to grab either:

A huge SQL query that creates a table with all 50 states and how to implement it into a signup form...

or...

A drop down list with all 50 states I can just copy and paste and edit? Id prefer this one.

Thanks! :wink:

Posted: Wed Apr 06, 2005 12:32 am
by feyd
usps.gov I'd imagine. :)

Posted: Wed Apr 06, 2005 12:37 am
by Fusioned
Oooh found a good one..thanks! It was a .gov site too! :P

Posted: Wed Apr 06, 2005 12:40 am
by Smackie
Well here is one is like a list for a form

Code: Select all

<FORM METHOD=&quote;POST&quote; ACTION=&quote;nextpage.cfm&quote;>
<SELECT SIZE=&quote;1&quote; NAME=&quote;Fruits&quote;>
<OPTION>Select an item</OPTION>
<OPTION VALUE=&quote;&quote;>USA</OPTION>
<OPTION VALUE=&quote;&quote;>Iowa</OPTION>
<OPTION VALUE=&quote;&quote;>Texas</OPTION>
</SELECT>
<INPUT TYPE=&quote;submit&quote; VALUE=&quote;Submit Fruit&quote;>
</FORM>
here is one for a menu

Code: Select all

<FORM 
ACTION=&quote;../cgi-bin/redirect.pl&quote; 
METHOD=POST onSubmit=&quote;return dropdown(this.gourl)&quote;>
<SELECT NAME=&quote;gourl&quote;>
<OPTION VALUE=&quote;&quote;>Choose a Destination...
<OPTION VALUE=&quote;USA&quote;                     >USA
<OPTION VALUE=&quote;IOWA&quote;                          >IOWA
<OPTION VALUE=&quote;TEXAS&quote; >TEXAS
</SELECT>
<INPUT TYPE=SUBMIT VALUE=&quote;Go&quote;>
</FORM>
hope one of them helps you

~Smackie~