private function _getValueCounts($field_id) { $db = DevblocksPlatform::getDatabaseService(); // Selected custom field if (null == ($field = DAO_CustomField::get($field_id))) { return; } if (null == ($table = DAO_CustomFieldValue::getValueTableName($field_id))) { return; } $sql = sprintf("SELECT field_value, count(field_value) AS hits " . "FROM %s " . "WHERE source_extension = %s " . "AND field_id = %d " . "GROUP BY field_value", $table, $db->qstr($field->source_extension), $field->id); $rs_values = $db->Execute($sql); $value_counts = array(); while (!$rs_values->EOF) { $value = $rs_values->fields['field_value']; $hits = intval($rs_values->fields['hits']); $value_counts[$value] = intval($hits); $rs_values->MoveNext(); } arsort($value_counts); return $value_counts; }