query about mysql statements
Posted: Sat Mar 22, 2003 7:03 am
hi
have a problem.. i have 2 tables players table and members table.. now in the members table i have the username, password, player1 - player11
in the player1 - player11 is the id for the playername which is in the players table..
in the players table is a id, playername, club.
when a member logs in and goes to the members page.. it displays the 11 players that the member picked!
but instead of displaying the name.. its displaying the id!
any ideas how to connect the tables so that when a person logs in using their user/pass the players names will be displayed instead of the id codes!
thanking you in advance!!!
have a problem.. i have 2 tables players table and members table.. now in the members table i have the username, password, player1 - player11
in the player1 - player11 is the id for the playername which is in the players table..
in the players table is a id, playername, club.
when a member logs in and goes to the members page.. it displays the 11 players that the member picked!
but instead of displaying the name.. its displaying the id!
any ideas how to connect the tables so that when a person logs in using their user/pass the players names will be displayed instead of the id codes!
thanking you in advance!!!