TalkPHP - View Single Post

StevenF · 02-15-2008, 01:16 PM

Success!

Stupid me. On the login script, I forgot the bring the decrypted password back, I was doing:

PHP Code:


			
$get = mysql_query("SELECT count(userID) FROM users WHERE user_name = '$user' AND user_pass = '$pass'");

        $result = mysql_result($get,0);

And now:

PHP Code:


			
$get = mysql_query("SELECT count(userID) FROM users WHERE user_name = '$user' AND user_pass = md5('$pass')");

        $result = mysql_result($get,0);

Sorry for my stupidity, I'm new to all this :) And thank you everyone for your help, greatly appreciate it.

Now I just need to read up about sessions

02-15-2008, 01:16 PM	#32 (permalink)
StevenF The Contributor Join Date: Jan 2008 Posts: 87 Thanks: 49	Success! Stupid me. On the login script, I forgot the bring the decrypted password back, I was doing: PHP Code: `$get = mysql_query("SELECT count(userID) FROM users WHERE user_name = '$user' AND user_pass = '$pass'"); $result = mysql_result($get,0);` And now: PHP Code: `$get = mysql_query("SELECT count(userID) FROM users WHERE user_name = '$user' AND user_pass = md5('$pass')"); $result = mysql_result($get,0);` Sorry for my stupidity, I'm new to all this :) And thank you everyone for your help, greatly appreciate it. Now I just need to read up about sessions __________________ My Personal and Photo Blog