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
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?