how to create module with table view and exposed filter

Hi

Have you looked at views. These are very powerful and may do what you want already.

Failing that, the core table functions may help. Do a search for theme('table' for examples.

I cut this out of one of my own Drupal 6 projects. It creates a two column table with headers.

Use db_query instead of pager_query if you do not want pagination. Also drop $output .= theme('pager', NULL, 25);.

<?php

function citations_view() {
  $header = array(
    array('data' => t('Tag')),
    array('data' => t('Citation')),
  );
  $sql = "SELECT * FROM {citations} c";
  $result = pager_query($sql, 25);
  $rows = array();
  while ($dblog = db_fetch_object($result)) {
    $row = array('data' =>
      array(
        $dblog->cid,
        theme('citation_cs', $dblog)
      ),
    );
    $rows[] = $row;
  }

  if (!$rows) {
    $rows[] = array(array('data' => t('No citations available.'), 'colspan' => 2));
  }

  $output = theme('table', $header, $rows, array('id' => 'cid'));
  $output .= theme('pager', NULL, 25);
  return $output;
}

?>