Views: exposed sort options

Thanks, but it does not work properly.

I have the following:

Views name: taxonomy_term
Filters: Node title asc
Filters: Node title desc

Views header code:

<form action="" method="GET">
<label>Sorteer op: </label>
<select onchange="this.form.submit()">
<option value="">Name (A to Z)</option>
<option value="title_za">Name (Z to A)</option>
</select>
</form>

Module file:

<?php

function studion_viewsfilter_views_query_alter( &$view, &$query ) {

  if ( $view->name == 'taxonomy_term' ) {
    $sort = $_REQUEST[ 'sort-order' ];
    if ( $sort == 'title_az' ) {
    	  	$query->orderby[ 0 ] = 'node_title ASC';
 			$query->orderby[ 1 ] = 'node_title DESC';
    }
	else {
      $query->orderby[ 1 ] = 'node_title DESC';
      $query->orderby[ 0 ] = 'node_title ASC';
    }
  }

}  
?>

the page just refreshes and nothing happens

I got a little lazy when I posted this.

The $query->orderby array should be

      $query->orderby[ 0 ] = 'node_[first_sort_criteria] ASC';
      $query->orderby[ 1 ] = 'node_[second_sort_criteria] ASC';
      $query->orderby[ 2 ] = 'node_[third_sort_criteria] DESC';
    } elseif ( $sort == 'pr_high' ) {
      $query->orderby[ 0 ] = 'node_[first_sort_criteria] DESC';
      $query->orderby[ 1 ] = 'node_[second_sort_criteria] ASC';
      $query->orderby[ 2 ] = 'node_[third_sort_criteria] DESC';
    } elseif ( $sort == 'title') {
      $query->orderby[ 0 ] = 'node_[second_sort_criteria] ASC';
      $query->orderby[ 1 ] = 'node_[third_sort_criteria] DESC';
      $query->orderby[ 2 ] = 'node_[first_sort_criteria] DESC';
    } else {	
      $query->orderby[ 0 ] = 'node_[third_sort_criteria] DESC';
      $query->orderby[ 1 ] = 'node_[first_sort_criteria] DESC';
      $query->orderby[ 2 ] = 'node_[second_sort_criteria] ASC';
    }

The way that I had it written originally wouldn't change the order of the sorting.

My bad. :/

This approach works in a great way. but unfortunately, not in my use case :( , I have a view of type "page" with a view of type "attachment" attached to it, using the approach stated here, one ends up editing the sorting of all queries and views on this page (the page view and the attachment)!

However, the approach found here works too, and enables you to generally manipulate specific displays :) (maybe only the page, or only one of the attachments attached to it)
http://stackoverflow.com/questions/2719850/how-to-change-the-sorting-of-...

it is based on hook_views_pre_view() you need to look at the answer not the question only:D