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

PEAR Manual

DB_result::numRows()

Synopsis

Description

Return value

Throws

Note

Example

See

Newsletter

Hosted by

Search

Links