Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
05-31-2004, 12:07 AM #1
- Join Date
- May 2004
- Sarnia, ON Canada
- Thanked 0 Times in 0 Posts
Drop Down Menu - Multiple Selections
I have a drop down menu of U.S. States; the value is the U.S. FIPS code. My target page is a table that contains the same FIPS value in one of the fields. I want to allow the selection of multiple states at 1 time, that will display cenus demographics for those states selected from the drop down.
I need a WHERE statement that will display ALL selected states; at present, only the last state selected will display in the target page. The WHERE statement I have is: usstatdm.fips LIKE '$a_state%'.
Any assistance would be greatly appreciated!