Hi, I'm new in this list and to PHP and MySQL. I'd welcome any help you can give.
I'm working on a simple application where a registered user submits a "forgot my password" form. The script is supposed to generate a random new password, write it to the database, and send it to the user. Then they can log in with the new password and they're off and running. Here's what happens now: The password generator works fine - it creates a random string any length I want. The password field in the database gets changed - not to the new random string but apparently to an encrypted version of it via the MySQL password() function. The script returns the user a notice of the new password. BUT, login with the new password fails! I'm reluctant to ask you to do my debugging but I'm almost brain dead after hours of trying to figure this out. Can someone suggest where I might look for the problem? I'll include my scripts in a reply if needed. Thanks very much in advance. Jim
