| 5 tablesort.inc | tablesort_sql($header, $before = '') |
| 6 tablesort.inc | tablesort_sql($header, $before = '') |
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
File
- includes/
tablesort.inc, line 38 - Functions to aid in the creation of sortable tables.
Code
<?php
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";
}
}
?>