Help for a DB problem

boboli

Hi all....I'm creating a system to manage a fantasy league. I have 16 teams divided in 2 groups. This is the actual DB:

Table USERS
userID
username
password
team_name

Table PLAYERS
playerID
player_name
player_position

Table PLAYERS_USERS
playerID (NOT UNIQUE)
userID (NOT UNIQUE)

I had to create this last table because 1 player can play for 2 different teams (one team per group)

NOW...I have a login page where I pass the userID to the formation page. In this page through a SELECT I need to SHOW the players of that specific team...is it possible to JOIN the
USERS.userID WITH the PLAYERS_USERS.userID and PLAYERS_TEAMS.playerID
WITH the PLAYERS.playerID in order to diplay all the players of the logged in person ???

Say userID =1 to show all the PLAYERS_USERS.userID=1 showing the player_name and player_position coming from the PLAYERS table instead of just the playerID ?????

Hope to have been enough clear.....

😕

HAPPY NEW YEAR !!!!!!!!!!!!!

Roberto

nnichols

SELECT player_name, player_position 
FROM USERS, PLAYERS, PLAYERS_USERS
WHERE USERS.userID=1
AND USERS.userID=PLAYERS_USERS.userID
AND PLAYERS_USERS.playerID=PLAYERS.playerID

Hope this helps 😉

boboli

It worked great !!!!!! Now I have to understand how to pass the variable $user_id from the login page to the query.....

thanx
Roberto

nnichols

When you create a login script, typically you would store the user_id as a session variable. That way it is available as a check to see if the user is logged in or not, and also to provide user specific information such as this.

Good luck 😉

boboli

Originally posted by nnichols
When you create a login script, typically you would store the user_id as a session variable. That way it is available as a check to see if the user is logged in or not, and also to provide user specific information such as this.

Good luck 😉

that was exactly what I was thinking about..... change the query to .....WHERE USERS.userID=$user_id

thanx again
Roberto