Description:
------------
im getting an error when doing a second update on the same record in the database.

mysqli_affected_rows() always returns 0 after the first update if you are trying to update the same record.

ive used the mysql console to perform the same update and that works fine.


Reproduce code:
---------------
$conn = mysqli_connect("localhost","root","****","****");

mysqli_autocommit($conn, FALSE);

$result = mysqli_query($conn,"update users set password = '$md5' where username = '$myvar' ");
echo mysqli_affected_rows($conn)."<br />";

//check that no errors have occured or warnings
if (mysqli_warning_count($conn) == null )
{
	echo mysqli_affected_rows($conn)."<br />";

	if ( mysqli_affected_rows($conn) > 0)
	{
                echo "some data";	
		mysqli_commit ($conn);
	}
}
else
{
	echo "error";
	mysqli_rollback($conn);
}
mysqli_free_result($result);
mysqli_close($conn);
}


Expected result:
----------------
it should return > 0 for mysqli_affected_rows and run the following code

Actual result:
--------------
returns 0 if updating the same record