URGENT HELP!!
Posted: Fri Mar 21, 2003 6:56 am
im newbie a this so bear with me..
im creating a football site which when a person registers.. they pick user/pass and get 2 pick 11 players.. this goes to my database.
when i log in using user/pass it goes to the members area.
i want it to display the 11 players on that page for that member!
im using sessions
i have the following query in my members page
$qstr = "SELECT player1 from members2 where username = [$SESSION_UNAME]";
$result = mysql_query($qstr);
is that right??
but then how do i call it??
get the name of the player1 to appear on the members area etc..
Thanking you in advance
im creating a football site which when a person registers.. they pick user/pass and get 2 pick 11 players.. this goes to my database.
when i log in using user/pass it goes to the members area.
i want it to display the 11 players on that page for that member!
im using sessions
i have the following query in my members page
$qstr = "SELECT player1 from members2 where username = [$SESSION_UNAME]";
$result = mysql_query($qstr);
is that right??
but then how do i call it??
get the name of the player1 to appear on the members area etc..
Thanking you in advance