I've got a three table database, with tables member, race, and results.
The site is just for a running club to record their race results and keep details on each member.
I want to have a page where users can view race results, i.e. display the members name (stored in member) the race they took part in, the data of the race (stored in race), and the time they achieved (stored in results). I understand i will need a join query to do this, this isn't the part thats bothering me..
I would prefer to let the user narrow down the results shown e.g. by the race name - there are about 10 different race names, and it would be nice for the user to select a race name (e.g. from a drop down box or some other method) and the page then reload displaying results only from that race.
Unfortunately not got a clue how to do this, can anyone give me some pointers? I only know how to display the whole lot and need to learn methods of letting the user narrow down the results. I'm rather a newbie at this stuff too unfortunately, so some simple clear help would be appreciated 🙂
