function tablesort_sql in Drupal 4

Same name and namespace in other branches

1. 5 includes/tablesort.inc \tablesort_sql()
2. 6 includes/tablesort.inc \tablesort_sql()

Create an SQL sort clause.

This function produces the ORDER BY clause to insert in your SQL queries, assuring that the returned database table rows match the sort order chosen by the user.

Parameters

$header: An array of column headers in the format described in theme_table().

$before: An SQL string to insert after ORDER BY and before the table sorting code. Useful for sorting by important attributes like "sticky" first.

Return value

An SQL string to append to the end of a query.

Related topics

12 calls to tablesort_sql()

comment_admin_overview in modules/comment.module

Menu callback; present an administrative comment listing.

forum_get_topics in modules/forum.module

path_overview in modules/path.module

Return a listing of all defined URL aliases.

statistics_node_tracker in modules/statistics.module

statistics_recent_hits in modules/statistics.module

Menu callback; presents the "recent hits" page.

... See full list

File

includes/tablesort.inc, line 38

Functions to aid in the creation of sortable tables.

Code

function tablesort_sql($header, $before = '') {
  $ts = tablesort_init($header);
  if ($ts['sql']) {
    $sql = db_escape_string($ts['sql']);
    $sort = drupal_strtoupper(db_escape_string($ts['sort']));
    return " ORDER BY {$before} {$sql} {$sort}";
  }
}