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

Reply via email to