function views_handler_sort_random::query in Views (for Drupal 7) 6.2

Same name and namespace in other branches

1. 6.3 handlers/views_handler_sort_random.inc \views_handler_sort_random::query()
2. 7.3 handlers/views_handler_sort_random.inc \views_handler_sort_random::query()

Called to add the sort to a query.

Overrides views_handler_sort::query

File

handlers/views_handler_sort_random.inc, line 7

Class

views_handler_sort_random

Handle a random sort.

Code

function query() {
  global $db_type;
  switch ($db_type) {
    case 'mysql':
    case 'mysqli':
      $formula = 'RAND()';
      break;
    case 'pgsql':
      $formula = 'RANDOM()';
      break;
  }
  if (!empty($formula)) {
    $this->query
      ->add_orderby(NULL, $formula, $this->options['order'], '_' . $this->field);
  }
}