jim
with my veeeery little experteez what i do is
$password= time();
store this password into db
and mail it out to the member ....
all in the same file :)
what this does is not only a unique password for all my members its
also pretty difficult to apprehend ..... let alone anythin else
hope this helps
good luck
toby ......
--- Uttam <[EMAIL PROTECTED]> wrote: > what command are you using to
change the password?
>
> *if you are using GRANT then you don't need to use PASSWORD()
> function,
> unless you use IDENTIFIED BY PASSWORD clause
> *if you are using INSERT or SET then you need to use PASSWORD()
> function to
> encrypt the password.
>
> see the actual password stored in database and compare it with
> encrypted
> user password [
> PASSWORD('userpasssword')], both should match.
>
> hope that helps!
>
> regds,
>
> -----Original Message-----
> From: Beach, Jim [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 03, 2003 21:16
> To: [EMAIL PROTECTED]
> Subject: script not allowing login after generating new password
>
>
> 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
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
