PEAR Manual
Prev |  | Next

# 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 33-1. Possible PEAR_Error values

Error code | Error message | Reason | Solution
--- | --- | --- | ---
`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 33-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()

Prev | Home | Next
DB_common | Up | DB_common::autoCommit()