check fields in db and overwrite one

[reel_biggy_fish]

oh okay i could easily just create a drop down menu and let them select from a wide choice.

 

would this mean when they type their secret question would i have to display their secret question? or could i not have to do that and make sure they remember it?

 

thanks again for your help. i have kinda understanding what i have to do

[petroz]

Show them the question. Most people that can't remember their password might have trouble remembering their question...

[reel_biggy_fish]

ahh okay thanks for clearing that one up.

 

so i presume from all of this i would do

("SELECT * FROM `user` WHERE `question` = '$n'"));

run the query, and then display the results in a textbox

[petroz]

No.. I would recommend locking each question and answer to each user.. just make an additional field for question and answer for your user table...

[reel_biggy_fish]

im sorry youve confused my with that by saying locking the question and answer?

[petroz]

Basically... when the user is prompted to enter their answer to their security question, make sure you are showing them the right question.

 

[reel_biggy_fish]

ohhh okay i understand you.

 

isnt that just

$n = $_POST['username'];

select question from securityq where usern = $n