Can anybody help with this Php Question

[marshy28]

Can anybody help with this Php Question

On my website I have a members login page which uses Php with a MSQL database. When a new member wants to join it gives them a random password to login in with but once they have verifyed there email and loged in I want them to be able to change the password but dont know how to acheive this.

If anyone can help I will send more information
_________________
Best Regards

Marshy
email@douza.co.uk

[Khalid Ali]

you will need to creae another page interfaced with database so once a user is validated his/her login they can go to update their personal info.

[marshy28]

sounds very complex to do is there any tutorils to help or have you any further help for me

[Jona]

If you have it where they login, make a new page with a form on it. The form has to have the following fields:

1. Username
2. Old password
3. Retype old password (verification)
4. New password

Then you MySQL query would look something like this...


$sql = "UPDATE `table_name` SET `column_name` = 'value' WHERE `password` = '". $_POST["old_password"] ."'";


[J]ona

[marshy28]

Thanks Jona

Sorry to be a pain in the *** but you havent got a working example for me to get my teeth into have you. Its just I find it easyier to learn that way if I can fully read the whole script and chop and change bits to suit

If not dont worry I will learn it some how

Thanks Anyway

Marshy

[Jona]

Nope, but if you need more example code, or an example form, I'd be happy to continue helping you...

[J]ona