Posted by Richard Lynch on 01/14/05 01:07

Tom wrote:
> 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)

How many rows actually had 'Tom' for their clientName?...

I mean, is the '1' wrong because it should be 4, or is it changing records
it shouldn't?

--
Like Music?
http://l-i-e.com/artists.htm

• Next in thread: Re: [PHP] mysql improved extensions affected_rows
• Prev in thread: mysql improved extensions affected_rows
• Next in forum: Re: [PHP] [Fwd: [PHP-INSTALL] Install of PHP 5.0.3 Error]
• Prev in forum: Re: [PHP] [HAB] Force Browsers to encode in utf8
• Thread view: mysql improved extensions affected_rows

[Reply to this message]