Thanks for your suggestions. Nathan
James Keeline <[EMAIL PROTECTED]> wrote: --- 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 --------------------------------- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed]
