Hello again everyone. I am trying to join 3 db’s together so i can echo out 1 string containing team name, player name and position.
Tables are set up as follows
team
team_id (Pk) auto ++
name
position
position_id (Pk) auto ++
position_name
players
player_id (Pk) auto ++
team_id
position_id
name
i tryed an sqlquery in phpMyAdmin but no luck
SELECT * FROM team, positions, players
WHERE team.team_id = 1
[COLOR=Red] AND team.team_id = players.team_id(error on this line)[/COLOR]
AND players.position =players.position _id
Anyone have any idea if im doing this correctly?
