No - instead, update the password with a new, random one, and e-mail the random one to the user.
- Jonathan -----Original Message----- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 1:37 PM To: MySQL List Subject: PASSWORD() question Hello, I have some usernames and passwords. The passwords have had the PASSWORD() function used on them. I need to set up an area of a site to allow users to have their passwords e-mailed to them. I can't just say SELECT password FROM table WHERE email='$email' AND username='$username' because that will give me a bunch of gibberish. Is there anyway to get the password back into plaintext to be emailed to the user? Thanks, Tyler Longren --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
