mysql improved extensions affected_rows

[Tom <tom@xxxxxxxxxxxxxxxxxxxxx>]

I've just started playing with the php5 improved mysqli extensions.

I have the following code:-

<?php
$mysqlim = new mysqli("localhost", "myUser", "myPassword","myDB");

$updateQuery = "UPDATE client SET status = 'INACTIVE' WHERE clientName = 
'Tom'";

if ($mysqli->query($updateQuery))
{
   $updateCount = $mysqli->affected_rows;
   echo "<br>updateCount = $updateCount";
}
else
{
   excpetionHandler("updateFailed: ".$updateQuery);
}
?>


This returns "updateCount = 1"
However, when I check the underlying table, there are actually 4 rows 
updated (and yes, before anyone asks, I have repeated this several 
times, correctly resetting the data before each run)

Is this a known bug, or am I doing something stupid?
(php 5.0.2, apache 2.0.49)

Thanks

Tom

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php