Description

Number of rows affected by a data manipulation query (for example INSERT, UPDATE or DELETE). Returns 0 for SELECT queries.

Return value

integer - number of rows or a DB_Error object on failure

Throws

Note

This function can not be called statically.

Example

<?php
// Once you have a valid DB object named $db...
$res =& $db->query('DELETE * FROM clients');

if (PEAR::isError($res)) {
    die($res->getMessage());
}

echo 'I have deleted ' . $db->affectedRows() . ' clients';
?>

See

numRows(), numCols(), query(), execute(), autoExecute(), executeMultiple()