->count()

Description

It performs a select count() request on the tables key column and returns the number of resulting rows. The default condition applied to the count() is a combination of the object variables and whereAdd settings. If the constant DB_DATAOBJECT_WHEREADD_ONLY is passed in as the first parameter then only the whereAdd settings will be used.

Parameter

• boolean $useWhereAddOnly - use only the whereAdd conditions (by default, count will only use both the object settings and the whereAdd conditions)

Return value

int - number of results

Note

This function can not be called statically.

Example

$person = new DataObjects_Person;

$person->whereAdd('name like '%test%');
$total = $person->count();

echo "There are {$total} people with a name like test";

SELECT count(id) FROM person WHERE name like '%test%'