////////////////////////////////////////////////////////////////////////////////////////////
if(!isset($_POST['page'])){
$page = 1;
} else {
$page = $_POST['page'];
}
// Define table name to search from
$table_name = 'news';
// Define the number of results per page
$max_results = 10;
$max_page_links = 10;
// Figure out the limit for the query based
// on the current page number.
$from = (($page * $max_results) - $max_results);
// Perform MySQL query on only the current page number's results
$sql = "SELECT nId, title, storyDate, author, story FROM news";
$org_result = mysql_query($sql) or die("SQL error: ".__FILE__.":".__LINE__.": $sql");
$total_results = mysql_num_rows($org_result);
$sql .= " ORDER BY storyDate DESC LIMIT $from, $max_results";
$org_result = mysql_query($sql) or die("SQL error: ".__FILE__.":".__LINE__.": $sql");
if ($total_results < 1) {$buffer = ' No news';} else
{
$to = ($from+$max_results < $total_results) ? $from+$max_results : $total_results;
// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);
// Build Page Number Hyperlinks
$nav_form = "Show $page of
$total_pages pages
Total $total_results stories
";
$navigation = "
";
// Build Previous Link
if($page > 1){
$prev = ($page - 1);
$onclick = 'document.nav.page.value = '. $prev .'; document.nav.submit()';
$navigation .= "
<< Previous ";
}
if ( $page - $max_page_links/2 < 1 ) {
$start = 1;
} else {
$start = $page - $max_page_links/2;
}
//echo $start.'
';
if($start + $max_page_links > $total_pages){
$start = $total_pages - $max_page_links;
}
if ($start < 0) $start = 1;
//echo $start;
if ( $start + $max_page_links > $total_pages ) {
$end = $total_pages;
} else {
$end = $start + $max_page_links;
}
for($i = $start; $i <= $end ; $i++){
$onclick = 'document.nav.page.value = '. $i .'; document.nav.submit()';
if(($page) == $i){
$navigation .= "
$i ";
} else {
$navigation .= "
$i ";
}
}
// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
$onclick = 'document.nav.page.value = '. $next .'; document.nav.submit()';
$navigation .= "
Next >> ";
}
$navigation .= "
";
$buffer = '';
if ($total_results > 0)
while ($news_info = mysql_fetch_array($org_result))
{
$story = substr( strip_tags($news_info['story']), 0, 200 ) . '...';
$link = 'index.php?page=newsview&nId='.$news_info['nId'];
$buffer .= '
'.$news_info['title'].'
'. $story .'
Author: '.$news_info['author'].'
Post Date : '.$news_info['storyDate'].'
';
}
}
?>
=$nav_form?>=$navigation?>
=$buffer?>
=$navigation?>





