Jump to content


Photo

Soccer Matches


  • Please log in to reply
1 reply to this topic

#1 stb74

stb74
  • Members
  • PipPipPip
  • Advanced Member
  • 71 posts
  • LocationNorthern Ireland

Posted 30 July 2006 - 08:01 AM

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
nifootball.co.uk

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

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