mysql improved extensions affected_rows
| From: | Tom | Date: | Thu, 13 Jan 2005 10:31:57 +0000 |
| Subject: | mysql improved extensions affected_rows | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-206287@lists.php.net to get a copy of this message | ||
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