Re: DB : affectedRows() on an UPDATE query ?

["Tomas V.V.Cox" <cox@idecnet.com>] > 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"; Please note that for "delete from users" DB_mysql::affectedRows won't give you what you expect unless you set the "optimize" option to "portability" for that DB connection. - Stig -- Stig Sæther Bakken <ssb@alltheweb.com> Fast Search & Transfer ASA, Trondheim, Norway