Update code. Solved.

[yungbloodreborn]

I'm not sure if this is the best place to post this question, but since it's dealing directly with mysql, it seemed right.

I have a snippet of code that says it's working, but it isn't.
[code]
$sql = mysql_query("UPDATE users SET email_address='$new_email_address', info='$info2' WHERE username='$username'");

if(!$sql){
    $message = 'There has been an error updating your profile. Please contact the webmaster.';
    include 'message.php';
} else {
    $message = 'Your profile has been updated!';
    include 'message.php';
}
[/code]

It says it updates my profile, but it doesn't. But when I run the same line directly in phpmyadmin, it works fine. I'm using one file that has all the database info (server, login, pass, table) and it works fine for everything else.

[fenway]

Check mysql_error() and see what you get. 

[yungbloodreborn]

[code]
$sql = mysql_query("UPDATE users SET email_address='$new_email_address', info='$info2' WHERE

username='$username'") or die (mysql_error());

echo $sql;
[/code]
It prints a 1 for the $sql, and nothing for the mysql_error

[fenway]

Well, then your UPDATE is "successful"... that is, no errors were generated.  Are you sure that the $username can be found?

[yungbloodreborn]

fenway,
  I found the problem. You pointed me in the right direction. You're right, it wasn't seeing $username because I had session_start() in the form that gets included, but not for the rest of the script. As soon as I put it at the top of this script, it worked perfectly. Thanks!! :)