Posted By

weitzman on 08/16/06

Tagged

Versions (?)

Last Edited at 08/16/06 10:31am

Statistics

Viewed 649 times

Favorited by 2 user(s)

Related snippets

query and iterate

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

\$sql = "$1";
\$header = array(
  array('data' => t('$2'), 'field' => '$3', 'sort' => '${4:asc}'),
  array('data' => t('$5'), 'field' => '$6'),
  array('data' => t('$7'), 'colspan' => '2')
);
\$sql .= tablesort_sql(\$header);
\$result = pager_query(\$sql, 50);
 
\$destination = drupal_get_destination();
while (\$row = db_fetch_object(\$result)) {
  $rows[] = array(\$row->, \$row->, array(), \$destination));
}
 
if (\$pager = theme('pager', NULL, 50, 0, tablesort_pager())) {
  \$rows[] = array(array('data' => \$pager, 'colspan' => '2'));
}
 
if (!\$rows) {
  \$rows[] = array(array('data' => t('$8'), 'colspan' => '2'));
}
 
return theme('table', \$header, \$rows);