PEAR Manual
Prev |  | Next

# DB_result::numRows()

DB_result::numRows() -- Gets number of rows in a result set

## Synopsis

``integer numRows` ()`

## Description

Get the number of rows in a result set.

Warning
For `ibase`, `ifx` and `oci8`, this method only works if the `DB_PORTABILITY_NUMROWS` portability option is enabled. In addition, for `ibase` and `ifx`, PEAR DB must be at version 1.7.0 or greater. Does not work for Microsoft Access.

## 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 | Driver doesn't support this feature. | Either switch to another database system or enable the `DB_PORTABILITY_NUMROWS` portability option.

## Note

This function can not be called statically.

## Example

Example 33-1. Using numRows()
    <?php
    // Once you have a valid DB object named $db...
    $res =& $db->query('SELECT * FROM phptest');
    echo $res->numRows();
    ?>

## See

numCols(), affectedRows()

Prev | Home | Next
DB_result::numCols() | Up | DB_Error