Posted By

ReeceMarsland on 01/07/10

Tagged

mysql
drupal

Versions (?)

Last Edited at 01/07/10 07:09am

Statistics

Viewed 644 times

Favorited by 1 user(s)

Related snippets

hook_views_query_alter Drupal 6.x (substring)

/ Published in: PHP

Highlighted TextExpand

/**
* Implementation of hook_views_query_alter().
*/
function local_views_query_alter(&$view, &$query) {
  if ($view->name == 'our_partners' && $view->current_display == 'page_1') {
    //alter the query so we actually select the results with the surname begining with the arg
		$query->where[0]['clauses'][3] = "SUBSTR(reverse(node.title), locate(' ', reverse(node.title)) - 1, 1) = '%s'";
  }
  if($view->name == 'our_people' && $view->current_display == 'page_1') {
		//alter the query so we actually select the results with the surname begining with the arg
		$query->where[0]['clauses'][2] = "SUBSTR(reverse(node.title), locate(' ', reverse(node.title)) - 1, 1) = '%s'";
  }
  if($view->name == 'our_people' && $view->current_display == 'attachment_1') {
		//alter the query so we actually select the results with the surname begining with the arg
		$query->fields['title_truncated']['field'] = "SUBSTRING( reverse( TRIM( node.title ) ) , locate( ' ', reverse( TRIM( node.title ) ) ) -1, 1 )";
  }
  if($view->name == 'our_partners' && $view->current_display == 'attachment_1') {
		//alter the query so we actually select the results with the surname begining with the arg
		$query->fields['title_truncated']['field'] = "SUBSTRING( reverse( TRIM( node.title ) ) , locate( ' ', reverse( TRIM( node.title ) ) ) -1, 1 )";
  }
}

Report this snippet Tweet