$db = ‘sciVital_petition’;
$table = ‘sciVital_formData’;
$connection = mysql_connect($host,$user,$pwd) or die(“Could not connect”);
mysql_select_db($db) or die(“Could not select database”);
$query = “SELECT COUNT(*) FROM {$table}”;
$result = mysql_query($query) or die(mysql_error());
$num_rows = mysql_fetch_row($result);
$pages = new Paginator;
$pages->items_total = $num_rows[0];
$pages->mid_range = 5; // Number of pages to display. Must be odd and > 3
$pages->paginate();
echo ““.$pages->display_jump_menu().$pages->display_items_per_page().”“;
echo $pages->display_pages();
$query = “SELECT Name, Position, Dept FROM {$table} ORDER BY ID DESC $pages->limit”;
$result = mysql_query($query) or die(mysql_error());
echo “
Name | Position | Dept |
---|---|---|
$row[0] | $row[1] | $row[2] |
“;
echo “
Page: $pages->current_page of $pages->num_pages
\n”;
echo $pages->display_pages();
?>