Description:
------------
I've got the problem similar to already reported here.

mysql_afftected_rows sometimes returns 0, sometimes 1. Although actually it does UPDATES the record. This query changes user login (password, e-mail) in the table "user" (see below. If it matters, MySQL is 3.23.53-max, Apache is 1.3.27):

Reproduce code:
---------------
mysql_query("UPDATE user SET ".$setRequest." WHERE login = '$userCurrentLogin' AND password = md5('$userCurrentPass')");
/* $setRequest is the string compiled conditionally, but I've just printed whole query string and it looked correct:

UPDATE user SET login = 'aaa' WHERE login = 'bbb' AND password = md5('ccc') */

$num = mysql_affected_rows();
if ($num == 0) $errorMsg = "Could not complete your request. Check the data";
else if ($num == -1) $errorMsg = "Database error. Try again later";
else $changeMsg = "Your data has been successfully changed";

Expected result:
----------------
Of course, I expect correct work of mysql_affected_rows :)

Actual result:
--------------
BUT the result ($num) is sometimes 0, sometimes 1, even if the record is actually updated.