This example shows all the information it takes to implement a simple pager.
$sql = "SELECT nid FROM node n WHERE type = '%s' AND status = %d ORDER BY created DESC";
$res = pager_query($sql, 5, 0, NULL, array('node_type_name', TRUE));
while ($res && ($row = db_fetch_array($res))) {
$node = node_load($row['nid']);
// Display node information here
}
echo theme('pager');
The query can be changed easily, as long as you update pager_query() with the right arguments.
theme('pager') displays the pager widget.