this article is taken from http://www.sononix.com/node/270 just placed here for reminder purposes

//This is numbers per page
$num_per_page = 5;

//actual query

$query = “SELECT n.nid, n.created FROM {node} n WHERE n.type = ‘halloffame’ AND n.status = 1 ORDER BY n.created DESC”;

//the count query should be similar to the query above
$count_query = “SELECT COUNT(*) AS row_count FROM {node} n WHERE n.type = ‘halloffame’ AND n.status = 1 ORDER BY n.created DESC”;

//pager_query function
$result = pager_query($query, $num_per_page, 0, $count_query, $user_load->uid);

//dont forget

while ($node = db_fetch_object($result)) {
$output .= node_view(node_load(array(‘nid’ => $node->nid)), 1);
}

$output .= theme(‘pager’, NULL, 5, 0);

print $output;

?>