MySQL Forums
Forum List  »  PHP

Using Drop down Menus To Search Results
Posted by: Marcus Nicolades
Date: May 06, 2005 10:00AM

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!!!!

Options: ReplyQuote

Written By
Using Drop down Menus To Search Results
May 06, 2005 10:00AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.