function main() {
extract($_REQUEST);
//pagination start
include "pagination.php";
$entries_per_page=9;
$page = (isset($_GET['page'])?$_GET['page']:1);
$result = mysql_query("SELECT * from testimonial order by id desc");
$num_rows = mysql_num_rows($result);
$total_pages = ceil($num_rows/$entries_per_page);
$pagination = pagination_six($total_pages,$page);
$offset = (($page * $entries_per_page) - $entries_per_page);
//pagination end
?>
TestimonialsPost Testimonials |
$fetch_res = mysql_query("select * from testimonial order by id desc limit $offset,$entries_per_page");
if(mysql_num_rows($fetch_res)>0) {
while($rows_values = mysql_fetch_array($fetch_res)) {
foreach($rows_values as $K1=>$V1) $$K1 = $V1;
?>
} } ?> |
if($num_rows > 12) echo $pagination; ?> |
if(mysql_num_rows($fetch_res)==0) { ?>
No Testimonials Found |
}
?>
|
|
}
include 'template.php';
?>