setting password expire

[mayreeh]

i nid to set a generated password to email, a link to the mail for user to change to a better password, now the generated password shold expire after few hours how do i do...at the moment am genearting the password effectivly, problem is settimng it expire...how do i do

[urtrivedi]

You must add one more column password_last_date, when u insert record, add timestamp to that field.

Now when you check login, compare current datetime and datetime in that password_last_date field to check whether it is expired or not.

[mayreeh]

thenx, d how do to get to capture the password and usernae in a link sent in the email to send it to database? please