fid, PROFILE_PUBLIC_LISTINGS); while ($record = db_fetch_object($result)) { $fields[] = $record; } $arguments = array($field->fid); switch ($field->type) { case 'checkbox': $query = 'v.value = 1'; break; case 'selection': $query = "v.value = '%s'"; $arguments[] = $value; break; case 'list': $query = "v.value LIKE '%%%s%%'"; $arguments[] = $value; break; default: drupal_not_found(); return; } $result = pager_query("SELECT u.uid, u.changed, GREATEST(u.changed, u.created) as lastchange FROM {users} u INNER JOIN {profile_values} v ON u.uid = v.uid WHERE v.fid = %d ORDER BY GREATEST(u.changed, u.created) DESC", 20, 0, NULL, $arguments); $output = '