I downloaded the files for the session example (longer one without cookies) and for some reason the update script doesn't seem to work.

The page says:
Update Account Information
Here you can update your account information for viewing in your profile.

Here you can update your account information for viewing in your profile.

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

not sure what the problem is, i read through the code I downloaded and it seems fine.

-Mike

Think I found it...the downloadable file for update_account.php.03.txt has a mistake in it.

key part says:

     $query_update = "UPDATE user_info SET email = '" . $_POST['email'] . "', city
         = '" . $_POST['city'] . "', state = '" . $_POST['state'] . "', hobbies =
         '" . implode(", ", $_POST['hobbies']) . "' WHERE username = '" .
         $_SESSION['user_logged']. "' AND password = (password('" .
         $_SESSION['user_password'] . "';";

The end for the password section should be: "'));";

which you can see in the later queries...
-Mike