[PHP] Re: MySQL PASSWORD() Question

2002-08-27 Thread Tony Harrison
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 la

[PHP] Re: MySQL PASSWORD() Question

2002-08-26 Thread Richard Lynch
>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: In other words, you can *NEVER* "go backwards" from the password() function output to

[PHP] Re: MySQL password()

2002-07-29 Thread Lars Olsson
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'