Re: [PHP] mysql improved extensions affected_rows

2005-01-15 Thread Jochem Maas
Tom wrote: ... It correctly updates 4 rows, but returns 1 as the count. I think that this may actually be a mysql issue - I've put the same php/apache configs onto another similar box, the only difference being that the second box is mysql 5.0.1, whereas the problem is reported against 5.0.0

Re: [PHP] mysql improved extensions affected_rows

2005-01-14 Thread Richard Lynch
Tom wrote: > Richard Lynch wrote: > >>Tom wrote: >> >> >>>I've just started playing with the php5 improved mysqli extensions. >>> >>>I have the following code:- >>> >$mysqlim = new mysqli("localhost", "myUser", "myPassword","myDB"); >>> >>>$updateQuery = "UPDATE client SET status = 'INACTIVE' W

Re: [PHP] mysql improved extensions affected_rows

2005-01-14 Thread Tom
Richard Lynch wrote: Tom wrote: I've just started playing with the php5 improved mysqli extensions. I have the following code:- $updateQuery = "UPDATE client SET status = 'INACTIVE' WHERE clientName = 'Tom'"; if ($mysqli->query($updateQuery)) { $updateCount = $mysqli->affected_rows; echo

Re: [PHP] mysql improved extensions affected_rows

2005-01-13 Thread Richard Lynch
Tom wrote: > I've just started playing with the php5 improved mysqli extensions. > > I have the following code:- > > $mysqlim = new mysqli("localhost", "myUser", "myPassword","myDB"); > > $updateQuery = "UPDATE client SET status = 'INACTIVE' WHERE clientName = > 'Tom'"; > > if ($mysqli->query($upd

[PHP] mysql improved extensions affected_rows

2005-01-13 Thread Tom
I've just started playing with the php5 improved mysqli extensions. I have the following code:- $updateQuery = "UPDATE client SET status = 'INACTIVE' WHERE clientName = 'Tom'"; if ($mysqli->query($updateQuery)) { $updateCount = $mysqli->affected_rows; echo "updateCount = $updateCount"; } e