Foreign Keys in php?
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)