[PHP] Re: MySQL PASSWORD() Question

cheers Richard Lynch [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... If I insert a row's field's value using the PASSWORD() function, will I need to use it or another function to find that row using the same field? You'll need to do this when somebody tries to log in later:

[PHP] Re: MySQL PASSWORD() Question

If I insert a row's field's value using the PASSWORD() function, will I need to use it or another function to find that row using the same field? You'll need to do this when somebody tries to log in later: ?php $username = $_POST['username']; # Or $PHP_AUTH_USER or $_GET['username'] or ...

[PHP] Re: MySQL password()

To my knowledge it isn't possible to decrypt the PASSWORD function in MySQL (you need to use MySQL ENCRYPT/DECRYPT for that). However, it's possible to use PASSWORD on the user-provided string too. You could try the following code: $query=SELECT * FROM users where username='$PHP_AUTH_USER'