onedumbcoder Posted August 7, 2009 Share Posted August 7, 2009 lets say there is a team table that holders the name of the captain and than there is a team_players table that holds the information of all the players on that team. is there a way i can get the captains name and the number of players, and the information on all the players (name,age) in one query? Link to comment https://forums.phpfreaks.com/topic/169269-get-team-leaders-name-and-the-number-of-players-in-one-query/ Share on other sites More sharing options...
Maq Posted August 7, 2009 Share Posted August 7, 2009 is there a way i can get the captains name and the number of players in one query? Sure, you're going to have to use a JOIN. Can you post your table structure? Link to comment https://forums.phpfreaks.com/topic/169269-get-team-leaders-name-and-the-number-of-players-in-one-query/#findComment-893227 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.