Well, here is my problem...
I have two tables: hockeystats_players & hockeystats_teams
hockeystats_players has a few coloums for the players stats as well as a field called "team", which signifies which team they are on.
hockeystats_teams has a few coloumn for the team stats as well as a field called "team" which gives the name of the team and a "team_id" which is the shorter version of the team.
The Team = Tri-Town Thunder
Team ID = thunder
The players table uses the shorter ID however when I display stats as well as other things that uses the shorter name I would like to display the real team name "Tri-Town Thunder" instead of just "thunder".
Another problem is that this may be used for other hockey leagues so we do not know the team name, or the id used. So it will have to read from the database.
What do I have to do to get that to do that? I'm really stuck on this problem.