Jump to content


This topic is now archived and is closed to further replies.


Soccer Matches

Recommended Posts

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.


Share this post

Link to post
Share on other sites
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.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.