Re: DB : affectedRows() on an UPDATE query ?
| From: | Manuel Lemos | Date: | Mon, 06 Aug 2001 19:30:08 +0000 |
| Subject: | Re: DB : affectedRows() on an UPDATE query ? | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-1311@lists.php.net to get a copy of this message | ||
Hello,
"Tomas V.V.Cox" wrote:
>
> Sylvinus Prodi wrote:
> >
> > Hello all,
> >
> > It would be great to allow an affectedRows() (returning a DB_Result instead
> > of a DB_OK) with UPDATE or DELETE queries !
>
> affectedRows() works only with UPDATES/INSERT/DELETE queries.
>
> $db->query('delete * from users');
> echo "I have deleted " . $db->affectedRows() . " users";
>
> > It works with mysql but I dont know if it is possible with others db so that
> > it could be done
>
> It's implemented in all backends.
Ermm... Interbase API does not seem to provide a way for determine the
number of affected rows, so it is better to not assume that it works
with all backends.
Manuel Lemos