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


integer numRows ( )


Get the number of rows in a result set.

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


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.


This function can not be called statically.


Using numRows()

// Once you have a valid DB object named $db...
$res =& $db->query('SELECT * FROM phptest');
Gets number of columns in a result set (Previous) DB Error object (Next)
Last updated: Wed, 25 Nov 2015 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report or add a note.
View this page in:

User Notes:

There are no user contributed notes for this page.