I'd like to add a "History" section to my site where my members can get stats, scores etc. for our team throughout the years. I'd like to have the data inter-related.
For example; When a user clicks on the year "1978", a page with our opponent, score, date, location etc. is displayed. I'd then like the user to be able to click on an opponent and have a page displaying all of the dates, scores, etc of all of the meetings between our team and that opponent.
My server has mySQL and PHP. Aside from hiring an expert like you all (which I'd love to do but wallet won't allow) what would be the easiest way to put this together?
Thanks for your time and any advice you can offer.