Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Searching user table via drop down boxes

Quote Reply
Searching user table via drop down boxes
I would like to create a drop down box with a list of possible values for a column in the user table

Forinstance, one of the columns in my user table is "state". On my homepage (not /cgi-bin/gforum.cgi) but rather just my plain ole index.html i want to have a dropdown box with state selections, have the user hit "submit" and it do a query on the member directory for every user with that state - the tricky part is it must also check the value of another field.

So an example would be in the user table there is a column "owns_car" it has a value of 0 or 1 (0 no, 1 yes)

For a user to find all the other members who own a car in the state of TX I want them to be able to pull down "texas" hit "submit" and it query the member records for "owns_car = 1" AND "state=tx" The owns_car value would be hidden as the only selection the user sees is what state they want to search

how would that be done?

Last edited by:

fbm: Sep 30, 2003, 9:40 AM