Using Drop down Menus To Search Results

[Marcus Nicolades]

I now have over 25,000 individual records as I have constructed a database with race results in the following fashion

-------------------------------------------------------------------

Id event year pos athlete club cat time

-------------------------------------------------------------------

What I was meaning to ask you is the following

I want to create a pull down menu which will have two boxes:

1: Box one: select your year (defaulted)

2: Box Two: select your race (defaulted)

3: A Submit button (pretty obvious!!!)

So….when the user selects 1971 as the year, the second box(with race/event) is auto-populated from the database, you then hit submit and it prints all the rows for that year with that race name. Simple!!!! Oh and it is to sort the rows in order ascending by pos (position) of course !!!!


If you could help me solve the drop down box thing then it would be TOTALLY BRILL!!!!