Thanks, Tim. That is a good example of how to make a sorted table, but I'm looking for how to have more than one table on the same page, and have them all independently sortable. -Evan On 7/26/05, Tim Altman <web@timaltman.com> wrote:
On Tue, 26 Jul 2005 20:35:41 +0200, Evan Heidtmann <evan.heidtmann@gmail.com> wrote:
The pager API provides a nice way to have multiple page-able tables on one page: the $element argument to theme('pager') and pager_query().
But as far as I can tell, there is no way to do the same with the tablesort API. Am I mistaken?
I think so. Check out http://drupaldocs.org/api/4.6/function/comment_admin_overview. Specifically, the following lines should do what you want (IINM):
$sql = 'SELECT c.subject, c.nid, c.cid, c.comment, c.timestamp, c.status, c.name, c.homepage, u.name AS registered_name, u.uid FROM {comments} c INNER JOIN {users} u ON u.uid = c.uid WHERE c.status = '. db_escape_string($status); $sql .= tablesort_sql($header); $result = pager_query($sql, 50);
-- Tim Altman