Mysql Error Out Of Nowhere

[kingkong]

Correct this error please, thanks

Code:

$query = "UPDATE `users` SET `picture` = '$file_name' WHERE `username` ='$username'"; echo "debug: functions $query"; mysql_query($query); echo mysql_error(); echo mysql_info();
results in:

debug: functions UPDATE `users` SET `picture` = 'blahblah3964.gif' WHERE `username` ='blahblahusername'Rows matched: 1 Changed: 1 Warnings: 0

and yet...no rows were changed! I checked the entire database!

picture is a varchar, by the way. and file_name is a string. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[roberto]

You could try updating the query like this, not sure but you can try
php Code:

$query = sprintf("UPDATE `users` SET `picture` = '%s' WHERE `username` ='%s'", mysql_real_escape_string($file_name), mysql_real_escape_string($username));
Try printing the relevant portion of the db before and after the change to see if there is any difference whatsoever. Maybe set $blah = mysql_query($query); and verify $blah is okay? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[nicolas]

Without seeing the real error, it impossible for us to tell. Turn up your error reporting, paste the actual query here. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --