Hi Guys,

Iím a bit confused by something that I wanted to know about. Say I call a value from my database table matches on my php page ie:

<?php echo $team_id_one; ?> -which outputs the value 1

But team_id_one is a foreign key which derives from a table called teams

teams
Team_id | Name
1 | Harchester Town
2 | Mansfield Athletic

How do I get the team_id_one if I call out 1 from my matches table and reference it to my teams table so that the team name is called out is Harchester Town rather than the value 1?

Thanks

Chris