I want to use the DataSetPager for my modules, but I don’t know how to make it work, or print out anything.
The wiki has no information on how to use DataSetPager.
This is what I have so far ... how do I get datasetpager to work?
include_once "controls/datasetpager.class.php";
$sql = 'SELECT * FROM `offers`';
$rs = ($modx->db->query($sql));
$dp = new DataSetPager('',$rs, 10);
print $dp->render();
$pager = $dp->getRenderedPager();
$rows = $dp->getRenderedRows();
if($pager):
$pager = "Page $pager";
else:
$pager = "<br />";
echo "<table border='1' width='100%'>";
echo "<tr><td align='left'>$pager</td></tr>";
echo "<tr><td><ul>$rows</ul></td></tr>";
echo "</table>";
endif;
