stb74 Posted July 30, 2006 Share Posted July 30, 2006 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.ThanksScott Quote Link to comment Share on other sites More sharing options...
fenway Posted July 30, 2006 Share Posted July 30, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.