Display contents from Foreign Key?

Display contents from Foreign Key?

vinit9vinit9 Posts: 20Questions: 1Answers: 0


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.