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_id (Pk) auto ++
position_id (Pk) auto ++
player_id (Pk) auto ++
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?