The recordCount() method returns the number of records retrieved by the last select statement, or -1 if the database driver does not support the operation.
If $ADODB_COUNTRECS is set to true before a query is executed, then the number of records will be retrieved, even if the function has to be emulated by issuing a COUNT * on the query. This can result in slow responses.
/* * Existing database connection assumed */ $result = $db->Execute('SELECT * FROM act'); $recordCount = $result->recordCount();