Hi, I have setup a table with user login name and password. The password is encrypted with the MySQL's password(). How do I compare these info with the user's input.
I had $query = "select * from auth where usrname='$logname' and usrpass=password('$logpass')"; mysql_query($query); But I can't compare the passwords. If I take out usrpass=..., MySQL can find a match. Please help. Regards, Norman --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php