Custom sql query & display it in a table in drupal

drupalTest.php

<?php
$sql = 'SELECT name, email, mobile, place FROM {test}';
$header = array(
	array('data' => 'name', 'field' => 'name'),
	array('data' => 'email', 'field' => 'email'),
	array('data' => 'mobile', 'field' => 'mobile'),
	array('data' => 'place', 'field' => 'place'),
	);
$sql .= tablesort_sql($header);
$result = pager_query($sql, 50);
while ($data = db_fetch_object($result)) {
	$rows[] = array($data->name, $data->email, $data->mobile, $data->place);
}
if (!$rows) {
	$rows[] = array(array('data' => t('Empty -n results'), 'colspan' => '4'));
}
echo theme('table', $header, $rows);
echo theme('pager', NULL, 50, 0);
?>