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%'.

I'm running an Apache Server, Windows XP, MySQL and PHP. I can use either a MySQL statement or javascript.

Any assistance would be greatly appreciated!