Hi all.

Im developing an admin at the moment, which allows the user to create an account with email/password. The password is stored as an encrypted value in the DB using the sql 'PASSWORD' function.

Id like to provide a 'Lost your password' option on the login screen, which allows the user to input their email address and get mailed their password.

My query is how do I 'decrypt' the password so that the original gets mailed to the user?

Its currently mailing the encrypted version, which obviously will make no sense to the user.

Any help would be appreciated!