Display contents from Foreign Key?
Display contents from Foreign Key?
vinit9
Posts: 20Questions: 1Answers: 0
in DataTables
Hello,
I'm currently using DataTables to populate data into my table but stuck with a little issue .. I have a foreign key in the following array;
$aColumns = array('player_id','player_name', 'team_id', 'player_position', 'player_number', 'player_game');
'team-id' is the foreign key but I want it to display the 'team_name' instead from the "teams table"? Is this possible? I also have inline editing so would this be an issue when making changes to the team name with ID?
confusing right?
This discussion has been closed.