Untitled

<?php

$Host = "*";
$User = "*";
$Password = "*";
$DBName = "*";

function setPageNumbers($total_results, $print_query, $page_name, $results_per_page, $page, $max_pages_to_show) {

    $pnums = "";
    if($page != 1) {
        $pageprev = $page - 1;
        $pnums .= "<a href='" . $page_name . $print_query . "page=" . $pageprev . "'>" . "< Prev </a>";
    }
    $showpages = round($max_pages_to_show);
    $numofpages = ceil($total_results/$results_per_page);
    if ($numofpages > $showpages ) {
        $startpage = $page - $showpages ;
    } else {
        $startpage = 0;
    }
    if ($startpage < 0){
        $startpage = 0;
    }
    if ($numofpages > $showpages ) {
        $endpage = $page + $showpages;
    } else {
        $endpage = $showpages;
    }
    if ($endpage > $numofpages){
        $endpage = $numofpages;
    }
    for($i = $startpage; $i < $endpage; $i++) {
        $real_page = $i + 1;
        if ($real_page!=$page){
            $pnums .=  " <a href='" .$page_name.$print_query."page=".$real_page."'>".$real_page."</a> ";
        } else {
            $pnums .=  " <b>".$real_page."</b> ";
        }
    }
    if(($total_results-($results_per_page*$page)) > 0){
        $pagenext = $page + 1;
        $pnums .=  "<a href='" .$page_name.$print_query."page=".$pagenext."'>Next > </a>";
    }
    return $pnums;

}


$Link = mysql_connect ($Host, $User, $Password);mysql_select_db($DBName);?><html><body bgcolor="#FFFFFF" text="#000000">
<?  // initialize paging options
if (strlen($_GET['page'])>0) {
    if ($_GET['page'] <= 0) {
        $current_page = 1; // default current page to 1 if value <= 0
    } else {
        $current_page = $_GET['page'];
    }
}
else {
$current_page = 1;
}

$number_of_pages_shown = 10;
$number_of_pages = 20;
$rows_to_show = 60; // number of rows displayed on each page
$my_query = "SELECT * from pre "; // the query
// do paging math
$Result = mysql_query($my_query);
if ($Result) {      $number_of_rows = mysql_num_rows($Result);
// figure how many total pages
$number_of_pages = floor($number_of_rows / $rows_to_show);
$remaining_number_of_data = $number_of_rows % $rows_to_show;

if ($remaining_number_of_data >= 1) {           $number_of_pages = $number_of_pages + 1;        }   }

$page_navigation = setPageNumbers($number_of_rows, "?", $PHP_SELF, $rows_to_show, $current_page, $number_of_pages_shown);
?>
<?=$page_navigation?>
<table border="0" cellspacing="1" cellpadding="2">
<?  // set starting point for database query
if ($current_page == 1) { $start_row = 0; }
else { $start_row = $rows_to_show * ($current_page-1); }
// get only rows to be displayed
$Result = mysql_query($my_query." ORDER BY id DESC LIMIT ".$start_row.", ".$rows_to_show);
if ($Result) {      // loop through results & build table rows
while ($itemArray = mysql_fetch_array($Result)) {       ?>
<tr bgcolor="#f3f3f3" onmouseover="style.backgroundColor='#dfdfdf';"onmouseout="style.backgroundColor='#f3f3f3'">
<td><?=$itemArray[date]?>&nbsp;</td>
<td><?=$itemArray[type]?>&nbsp;</td>
<td><?=$itemArray[releasename]?>&nbsp;</td>
</tr>
<?
}
}
elseif (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;}  mysql_free_result($Result); ?>
</table>
<?=$page_navigation?>
<?  mysql_close($Link); ?>
</body>
</html>