function content_handler_argument_reference::title_query in Content Construction Kit (CCK) 6.2

Same name and namespace in other branches

1. 6.3 includes/views/handlers/content_handler_argument_reference.inc \content_handler_argument_reference::title_query()

Override the behavior of title().

File

includes/views/handlers/content_handler_argument_reference.inc, line 11

Provide handler to replace reference with title.

Class

content_handler_argument_reference

@file Provide handler to replace reference with title.

Code

function title_query() {
  $titles = array();
  $placeholders = implode(', ', array_fill(0, sizeof($this->value), '%d'));
  $table_data = views_fetch_data($this->name_table);
  $table = array_shift($table_data['table']['join']);
  $result = db_query("SELECT {$this->name_field} AS title FROM {" . $table['table'] . "} WHERE " . $table['field'] . " IN ({$placeholders})", $this->value);
  while ($row = db_fetch_object($result)) {
    $titles[] = check_plain($row->title);
  }
  return $titles;
}