PHP: MySQL update query

[bmaniero]

I need to have a page where the user can update his info and/or delete his record. I haven't tested the DELETE query yet.

When I open the page it shows all the info stored in the database. When I change something and hit the update button I get the message that the record was successfully updated, but nothing really hapens. I looked at the code over and over and over and I just cannot understand what I am doing wrong.

If you want to see what's happening go to www.bmwebdes.com/mapfgl/ , click on the 'directory' link
The user ID is 'scooby', and password 'dooby'. If it does not work, try the following combination: user ID: 'sunny', password: 'trout' . Then click on the 'edit profile' link and try to change something and see what happens.

I am attaching a txt file of the 'edit profile' page, the one I am having trouble with so you can see the entire code.

Thank you in advance for your help.

[khaldryck]

sorry i can't even log in with the login and pass you gave.

and your code is too heavy for me to check it fast.
(i don't have a lot of time to help everyone) ...

the best would be to echo all your queries, and test them one by one, to see where it bugs.

maybe it's $userid that isn't good, and so your update is trying to update user with id=''
the query succeed but don't update what you want this way.