Jump to content

Archived

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

stb74

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.

Thanks
Scott

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.