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?
Searching user tables via drop down boxes