Posted By

kurokikaze on 03/03/09

Tagged

table
drupal

Versions (?)

Last Edited at 03/03/09 05:01am

Statistics

Viewed 911 times

Favorited by 0 user(s)

Related snippets

Sorting by multiple columns

/ Published in: PHP

Use instead of standard "sql\_tablesort()" function. Handles multiple "sort" in $header, but the arrow will be only on last sorted column. This can be handled with rewriting theme_table, for example.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function multi_tablesort($header = array()) {
    $sorts = array('asc', 'desc');
    $sorter = '';
    $tablesort = array();
 
    foreach($header AS $field) {
        if (in_array($field['sort'],$sorts)) {
            $tablesort[] = db_escape_string($field['field']) . ' ' . drupal_strtoupper(db_escape_string($field['sort']));
        }
 
    }
 
    if (count($tablesort) > 0) {
        $sorter = 'ORDER BY ' . implode(', ', $tablesort);
    }
 
    return $sorter;
}