function _similar_taxonomy_names in Similar Entries 7

Same name and namespace in other branches

1. 5 similar.module \_similar_taxonomy_names()
2. 6 similar.module \_similar_taxonomy_names()

Queries for taxonomy names. http://drupal.org/node/51041

Return value

An array of taxonomy term names to be used.

1 call to _similar_taxonomy_names()

similar_block_configure in ./similar.module

Implements hook_block_configure().

File

./similar.module, line 289

Module that shows a block listing similar entries. NOTE: Uses MySQL's FULLTEXT indexing for MyISAM tables.

Code

function _similar_taxonomy_names() {
  $names = array();
  $query = db_select('taxonomy_term_data', 'd');
  $query
    ->addField('d', 'tid');
  $query
    ->addField('d', 'name', 'data_name');
  $query
    ->innerJoin('taxonomy_vocabulary', 'v', 'd.vid = v.vid');
  $query
    ->addField('v', 'name', 'vocab_name');
  $query
    ->addField('v', 'vid');
  $query
    ->fields('v', array(
    'vid',
    'name',
  ));
  $query
    ->orderBy('v.name', 'ASC');
  $query
    ->orderBy('d.name', 'ASC');
  $result = $query
    ->execute()
    ->fetchAll();
  foreach ($result as $data) {
    $names[$data->tid] = $data->vocab_name . ': ' . $data->data_name;
  }
  return $names;
}