Custom Query

There is a lady called Nancy ( She has made the drupal cookbook I think) she helped me like this.
Create a page and put this into it.

$sql = 'SELECT sted, selskab, vej, username FROM {test}';
$header = array(
array('data' => 'sted', 'field' => 'sted'),
array('data' => 'selskab', 'field' => 'selskab'),
array('data' => 'vej', 'field' => 'vej'),
array('data' => 'username', 'field' => 'username'),
);

$sql .= tablesort_sql($header);

$result = pager_query($sql, 50);

while ($data = db_fetch_object($result)) {
$rows[] = array($data->sted, $data->selskab, $data->vej, $data->username, str_repeat('--',$data->d).$data->title);
}

if (!$rows) {
$rows[] = array(array('data' => t('Empty at the moment..'), 'colspan' => '4'));
}

echo theme('table', $header, $rows);
echo theme('pager', NULL, 50, 0);

Is it something like this ?