View Single Post
Old 02-28-2007, 11:06 AM   #1
sturomanek
Green Mole
 
Join Date: Feb 2007
Posts: 1
basic php/mysql verification problem

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.
sturomanek is offline   Reply With Quote