loadTemplateFile("youandyourhealth.tpl",true,true); $tpl->setVariable("header",$header); $tpl->setVariable("left",$left_homecare); $tpl->setVariable("right",$right); $tpl->setVariable("footer",$footer); $adjacents = 3; $page=$_GET['page']; $query = "SELECT COUNT(*) as num FROM ".$homecare_news_tbl; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages[num]; $page_name="youandyourhealth.html"; if($total_pages > 0) { $limit = 10; //how many items to show per page if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 $sql = "SELECT * FROM ".$homecare_news_tbl." order by `date` LIMIT $start, $limit"; $query = mysql_query($sql); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 $pagination = ""; if($lastpage > 1) { $pagination .= "
"; //previous button if ($page > 1) $pagination.= "« previous"; else $pagination.= "« previous"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "".$counter.""; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "".$counter.""; else $pagination.= "".$counter.""; } $pagination.= "..."; $pagination.= "".$lpm1.""; $pagination.= "".$lastpage.""; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "".$counter.""; else $pagination.= "".$counter.""; } $pagination.= "..."; $pagination.= "".$lpm1.""; $pagination.= "".$lastpage.""; } //close to end; only hide early pages else { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "".$counter.""; else $pagination.= "".$counter.""; } } } //next button if ($page < $counter - 1) $pagination.= "next »"; else $pagination.= "next »"; $pagination.= "
\n"; } $tpl->setVariable("pagination",$pagination); while($row = mysql_fetch_array($query)) { $tpl->setVariable("title",$row['title']); $tpl->setVariable("news",$row['news']); $tpl->parse("homecare_news"); } } $tpl->show(); ?>