mysql Password() - Decode?

[rcbasie]

Hi!
I was wondering if there is any way of decoding a password that i stored on my MySQL database like this:

INSERT INTO table (user_id, password), VALUES ('$user_id', Password('$pass'))

I want to do an automatic password recovery page, where the user types in their email address and the PHP page emails their user ID and password to them.

Thankyou!!
Robin

[crimaniak]

password() is a one-way ticket. Generate new password and send it to user.

[rcbasie]

Good idea!