include ("../include/variabili.php");
include ("../include/funzioni.php");
mysql_select_db ("$database", $connection);
$pagina =$_REQUEST["pagina"];
?>
case vacanze sardegna
case vacanze sardegna nord ovest
include ("../include/menu-2007-sardegna-ita.php"); ?>
$regione="sardegna";
$zona="1";
$s_nome_read_sardegna="Nord Ovest";
$testo="";
if(!isSet($start)){$start = 0;}
$i=$start;
// conto le zone zone
$sql= "SELECT count(*) as c from tbl_circondario where s_zona='Nord-Ovest' and b_stato=1 order by i_id";
$result = mysql_query($sql, $connection);
while ($ris = mysql_fetch_array($result) )
{$count = $ris["c"];}
if ($count==0) {?>
Nessun risultato }
//query con paginazione
$records_per_page = 1;
$total_pages = ceil( $count / $records_per_page );
if ( !isset($pagina) ) { $pagina = 1; }
$offset = ( $pagina - 1 ) * $records_per_page;
$sql = "SELECT * from tbl_circondario where s_zona='Nord-Ovest' and b_stato=1 order by i_ordine";
$sql .=" LIMIT $offset,$records_per_page";
$result = mysql_query($sql, $connection);
while ($ris = mysql_fetch_array($result) )
{
$i_id_circondario_read = $ris["i_id"];
$s_nome_read = $ris["s_nome"];
include ("../include/struttura-2008-sardegna-case.php");
} //fine ciclo circondario
//************************ PAGINAZIONE **********************************
# this will set up the "First | Prev | " part of our navigation.
if ( $pagina == 1 ) {
# if we are on the first page then "First" and "Prev"
# should not be links.
$navigation = " ";
} else {
# we are not on page one so "First" and "Prev" can
# be links
$prev_page = $pagina - 1;
$navigation = " ";
}
# this part will set up the rest of our navigation "Next | Last"
if ( $pagina == $total_pages ) {
# we are on the last page so "Next" and "Last"
# should not be links
$navigation .= " ";
} else {
# we are not on the last page so "Next" and "Last"
# can be links
$next_page = $pagina + 1;
$navigation .= "";
}
//************************ PAGINAZIONE **********************************
if ($total_pages>=2){
?>