DB_common::affectedRows() DB_common::affectedRows() -- Finds number of rows affected by a data changing query
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
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';
?>
