From: nav at nc dot ru Operating system: Windows XP PHP version: 4.3.6 PHP Bug Type: MySQL related Bug description: mysql_afftected_rows returns 0 even when updates record
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. -- Edit bug report at http://bugs.php.net/?id=28871&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28871&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28871&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=28871&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=28871&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=28871&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=28871&r=needscript Try newer version: http://bugs.php.net/fix.php?id=28871&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=28871&r=support Expected behavior: http://bugs.php.net/fix.php?id=28871&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=28871&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=28871&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=28871&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28871&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=28871&r=dst IIS Stability: http://bugs.php.net/fix.php?id=28871&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=28871&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=28871&r=float