Select function.
Performs a SQL function such as COUNT(*), SUM(*), ... on a table field for those rows meeting conditions.
157 $functions = array(
'COUNT',
'SUM');
158 if (!in_array($function, $functions)) {
159 throw new Exception(
'Invalid database function.');
161 $query = db_select($this->table,
't');
162 $query->addExpression($function .
'(' . $key .
')');
163 foreach ($conditions as $condition) {
164 if (
count($condition) == 3) {
165 $query->condition($condition[0], $condition[1], $condition[2]);
167 elseif (
count($condition) == 2) {
168 $query->condition($condition[0], $condition[1]);
171 return $query->execute()->fetchField();
count($key, $value)
Count entries.
Definition: common.db.logic.inc:63