Author Topic: Affected rows function? (Read 2075 times)

barrylb · March 05, 2009, 07:52:33 pm

Quick question for someone... I'm using code like

CRM_Core_DAO::executeQuery("UPDATE mytable SET ...") to do some database queries. How can I access a function to return number of affected rows like mysql_affected_rows() ?
It looks to be in the code ... maybe a function called affectedRows() ... but I can't figure out how to access it.

Donald Lobo · March 05, 2009, 08:46:24 pm

$dao =& CRM_Core_DAO::executeQuery("UPDATE mytable SET ...");

$dao->N

should give you the number of affected rows (i think, do a print_r on $dao to make sure). You can also check the DB_DataObject documentation to see if there is a function for this

lobo

taram · March 19, 2009, 01:02:23 pm

Yes $dao->N has the effected number of rows. I have used this in my code.

CiviCRM Community Forums (archive)

News:

Author Topic: Affected rows function? (Read 2075 times)

barrylb

Affected rows function?

Donald Lobo

Re: Affected rows function?

taram

Re: Affected rows function?