Helping ordinary people create extraordinary websites!


PEAR Manual
PrevNext

DB_common::affectedRows()

DB_common::affectedRows() -- Finds number of rows affected by a data changing query

Synopsis

integer affectedRows ()

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

Table 39-1. Possible PEAR_Error values

Error codeError messageReasonSolution
DB_ERROR_NOT_CAPABLE DB backend not capable Function is not supported by the database backend Switch to another database system, if you really need this feature.

Note

This function can not be called statically.

Example

Example 39-1. Using affectedRows()

<?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()

PrevHomeNext
DB_commonUpDB_common::autoCommit()