selectFunctionField (   $function,
  $key,
array  $conditions 
)

Select function.

Performs a SQL function such as COUNT(*), SUM(*), ... on a table field for those rows meeting conditions.

Parámetros
string$keyThe field name. Must be SQL safe.
array$conditionsEach entry is a condition. A condition is an array of three therms.
156  {
157  $functions = array('COUNT', 'SUM');
158  if (!in_array($function, $functions)) {
159  throw new Exception('Invalid database function.');
160  }
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]);
166  }
167  elseif (count($condition) == 2) {
168  $query->condition($condition[0], $condition[1]);
169  }
170  }
171  return $query->execute()->fetchField();
172  }
count($key, $value)
Count entries.
Definition: common.db.logic.inc:63