Foreign Keys in php?

Hi Guys,

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

<?php echo $team_id_one; ?> -which outputs the value [b]1[/b]

But [b]team_id_one [/b] is a foreign key which derives from a table called [b]teams[/b]

[b]teams[/b]
Team_id | Name
1 | Harchester Town
2 | Mansfield Athletic

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

Thanks

Chris

Also in #PHP _↴