$per_page = 10; if (!$_GET['page']) {$_GET['page'] = 1;} $page_start = ($per_page * $_GET['page']) - $per_page; $querylimit = " limit $page_start,$per_page "; $prev_page = $_GET['page'] - 1; $next_page = $_GET['page'] + 1; $query_page = "SELECT * FROM htp_entries WHERE status = 'Published' ORDER BY id DESC"; $num_rows_page = mysql_num_rows(mysql_query($query_page)); if ($num_rows_page <= $per_page) {$num_pages = 1;} else if (($num_rows_page % $per_page) == 0) {$num_pages = ($num_rows_page / $per_page);} else {$num_pages = ($num_rows_page / $per_page) + 1;} $num_pages = (int) $num_pages; $entry = "SELECT * FROM htp_entries WHERE status = 'Published' ORDER BY id DESC"; $resultLimit = $entry.$querylimit; $query = mysql_query($resultLimit); if(mysql_num_rows($query)>0){ // PAGINATION echo "
"; if($num_rows_page > $per_page){ } // end if if ($prev_page){ echo "Previous "; } for ($i = 1; $i < $num_pages; $i++) { if ($i != $page) { echo " $i"; } else { echo " $i "; } } if($_GET['page']<$num_pages) { echo " Next"; } echo "
$ppmcphoto = "SELECT * FROM htp_photos WHERE entry_name = '".mysql_real_escape_string($row->name)."'";
$rppmcphoto = mysql_query($ppmcphoto) or die("Error query $ppmcphoto" . mysql_error());
if(mysql_num_rows($rppmcphoto)>0){
while($photo = mysql_fetch_object($rppmcphoto)){
?>
}// end while
}// end if
?>
} }
?>