PHP Mysql Login - Edit Single Row

[drumminlogan]

I am new to PHP and managed to make my first script for my site. It allows people to enter in their information. Then I have an admin area where I can edit each listing or delete them if needed. I want to make a login area where users can login and change their information. I have looked around and I am confused at how to go about doing this.

Can someone point me in the right direction of where I need to go so people can login and just edit their one row in my table.

By the way, I am using MySQL database.

Thanks.

[celibate54]

believe it or not, if you know how to let users register, you are pretty much there, code wise, in allowing them to edit it.

Just have some sort of trigger that a user can click (ie a link to a switch statement such as user.php?do=edit&user=blah)

then in the switch statement query the user's info then include a form that displays text fields and in the value for each field put the appropriate column name (ie value='memberId', value='password')

hope this helps...

EDIT: also, don't forget to session register whatever variables you need so when a user successfully logs in and clicks edit, he/she will be editing the appropriate fields and not their friendly neighbors!