basic php/mysql verification problem

[sturomanek]

im pretty new to php/mysql and have just been picking up what i can from the web. with that said, im trying to create a very basic way to log into a website using a table to store information like username and password (im sure this isn't the most secure way to go about this but thats irrelevant at this point)
so i pass the entered username and pass into the next document which is trying to verify it. my plan was to get php to retrieve the password from the table and then compare the two variables to insure a match. i get stuck on the retrieval part.
$db_pass = "";
$db_pass = mysql_query("
SELECT password
FROM users
WHERE username=$user");
if it ever prints out it prints Resource ID #2
i realize this is probably pretty basic, thanks for any help.

[keeen]

Try browsing the Phpdig user help database.