Make it easy on yourself: $pw = md5($password); $query = "INSERT INTO penpals (email, password, username) VALUES \"$email\",\"$pw"\,\"$username\")"; mysql_query($query);
$pw = md5($password); $query = "SELECT email,password,username FROM penpals WHERE email=\"$email\" && password=\"$pw\""; $result = mysql_query($query) or die(mysql_error()); rick "People will forget what you said. People will forget what you did. But people will never forget how you made them feel." ----- Original Message ----- From: "Vernon" <[EMAIL PROTECTED]> To: <> Sent: Monday, February 17, 2003 10:16 AM Subject: [PHP] MD5 login troubles Hey all, I'm using the following code to save an MD5 password into a database along with an unencrypted username and email address: $insertSQL = sprintf("INSERT INTO penpals (email, password, username) VALUES (%s, MD5(%s), %s)", All seems to have worked well, the password is encrypted and so forth. I have also attempted to use the following MySQL command to encrypt the password and came up with the same result: UPDATE penpals SET password = MD5(password) WHERE ID = 1 So the trouble seems to be with the login where I am using the following code: SELECT email, password, access FROM penpals WHERE email= '%s' AND password = MD5('%s') Am I missing something here? Am I some how double encrypting the password? Is there a de-encrypt function or something I'm missing? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php