Resource id #2 ???
Posted: Fri Apr 16, 2004 1:25 pm
hey guys...
ok i have a database with ppls address fonenum faxnum email login and password
now when that user is logged in
it starts a session and assigns a variable for the users name
$_SESSION['user']
i know this variable contains the right information because when i use the echo statement it displays the user's name
however... when i want to display a specific row from my database on the page --with the following code
$result = mysql_query("SELECT * FROM register WHERE login ='$_SESSION['user']'");
echo $result;
--- the page displays "Resource id #2"
can anyone help?
ok i have a database with ppls address fonenum faxnum email login and password
now when that user is logged in
it starts a session and assigns a variable for the users name
$_SESSION['user']
i know this variable contains the right information because when i use the echo statement it displays the user's name
however... when i want to display a specific row from my database on the page --with the following code
$result = mysql_query("SELECT * FROM register WHERE login ='$_SESSION['user']'");
echo $result;
--- the page displays "Resource id #2"
can anyone help?