Php Password recovery with secret question script

[Russia]

I am needing help designing password recover script.

 

This script must include a password recovery script.

 

I am needing for the person to reset there password, need to first answer a form named: Your Email.

 

If the email is found, it goes to another form that asks for the secret answer.

 

Then it goes to a form that asks the answer of there secret question that they entered when they first signed up.

 

If the answer is correct it updates the database table value of the password with a random string generated with:

 

abcdefghijklmnopqrstuvwxyz023456789

 

And it also, sends that password to the email provided.

 

What I am wanting to know, is how would the code with the if statements would be structured like and the column types and names.

 

Or if anyone has ever created something like this, and would be glad to post a snippet of there code would be great.