if (isset($_GET['page_no']) && $_GET['page_no']!="") {
$page_no = $_GET['page_no'];
} else {
$page_no = 1;
}
$total_records_per_page =5;
$offset = ($page_no-1) * $total_records_per_page;
$previous_page = $page_no - 1;
$next_page = $page_no + 1;
$adjacents = "2";
$total_records = $db->query("select * from instalaciones where tipo IN('MONUMENTOS','MUSEOS') order by tipo asc")->numRows();
$total_no_of_pages = ceil($total_records / $total_records_per_page);
$second_last = $total_no_of_pages - 1;
echo '
'._("Monumentos y Museos").'
';
$consulta=$db->query("select * from instalaciones where tipo IN('MONUMENTOS','MUSEOS') order by tipo asc LIMIT ?, ?", $offset, $total_records_per_page )->fetchAll();
foreach($consulta as $consulta){
$imagen_nombre = $db->query("select * from instalaciones_img where instalaciones = ? limit 1", $consulta['id'] )->fetchArray();
?>
}
?>
include '../pagination.php'; ?>