I am in the process of adding Cup matches to my site.
I have been able to get details of the matches displayed without any problems. I now wish to add details of what round the match is in. I.E Round 1, Semi - Final, Final.
I have created a new table called Rounds with details of the Rounds etc. I have added a link with roundID into the matches table.
I would like to know how I can display the round name from the Rounds table instead of the RoundID in the matches table.
1 reply to this topic
Posted 30 July 2006 - 04:35 PM
You'd need to use a JOIN on RoundID to link the two tables... post the query you have so far, and relevant fields, and I can show you how to change it.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users