--- sivsenxml_3969 <[EMAIL PROTECTED]> wrote: > I have a problem in encrypt and decrypt. I have created a database for > user registration using mysql. In that i have get the password from > the registration form and encrypt that using password() function in > mysql and stored the value in database. Again i am retrieving the > password from the database and i want to decrypt that. > > Please send me the suggestions to solve this problem. > > Thanks > Nathan
The MySQL function password() is a one-way encryption. There is not supposed to be a way to return that value to the original clear-text password input. Instead, you would use the same function to process the user input and see if the hashed values are the same. In theory, no two inputs should generate the same password hash. There are functions for encrypting and decrypting values based on a key and you may be looking for something like this: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html James Keeline
