Put at the top ofo the page:
<?
$conn=mysql_connect($hostname, $user, $pass);
$rows_per_page=20;
$sql="SELECT * FROM table";
$result=mysql_db_query($database, $sql, $conn) or Die ("Your Message".mysql_error());
$total_records=mysql_num_rows($result);
$pages=ceil($total_records / $rows_per_page);
mysql_free_result($result);
?>
...
<?
if (!isset($screen)) $screen=0;
$start=$screen * $rows_per_page;
$sql="SELECT fields FROM table ORDER BY field";
$sql.="LIMIT $start, $rows_per_page";
$result=mysql_db_query($database, $sql, $conn) or Die ("Your Message".mysql_error());
while (list($var1, $var2, ...)=mysql_fetch_row($result)) {
echo "$var1, $var2 ...</li>";
}
if ($screen>1) {
$scrm=$screen - 1;
$url="$PHP_SELF?screen=" . $scrm;
echo "<a href=\"$url\">Before</a>\n";
}
for ($i=0; $i<$pages; $i++) {
$url="$PHP_SELF?screen=" . $i;
echo " | <a href=\"$url\">".$i."</a> | ";
}
if ($screen < $pages-1) {
$scrp=$screen + 1;
$url="$PHP_SELF?screen=" . $scrp;
echo "<a href=\"$url\">After</a>";
}
?>
Its working
