Updating Records

[D_tunisia]

I have a user table and I want the user to to be able to edit certain parts of their user information.

For example, when they register they enter a username and email address. This is then stored in the user table. How can I make it so that they can change their email address later on?

Thanks.

[nelsons]

Consider this: Have a form that request two pieces of info: 1. username, 2. email address used when signing up.

Do a query, see if the two items match exactly on a single record in your db. (if username == username and email == email)

If so, redirect to to a page that allows them to enter new updated info.

If not, redirect to a help page, or a new member signup.

[D_tunisia]

Thanks.

I have actually mamaged to do what you have. The problem I am having is that I don't know the syntax to do the actual update.