include ("portovenere.inc");
$PVE=mysql_connect ("$PVEOST","$PVESER","$PVEASS");
/*
$SQL="select * from $HOTEL where flagbannerna100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
if ($PrimoBanner100=="") {
$SQL="select * from $RISTORANTI where flagbannerna100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
}
if ($PrimoBanner100=="") {
$SQL="select * from $SHOPPING where flagbannerna100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
}
if ($PrimoBanner100=="") {
$SQL="select * from $NAUTICA where flagbannerna100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
}
*/
if ($PrimoBanner100=="") {
$SQL="select * from $BANNER where flagbannerna100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
}
$VISBANNER100="S"; if ($PrimoBanner100=="") { $VISBANNER100="N"; }
/*
$SQL="select * from $HOTEL where flagbannerna200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
if ($PrimoBanner200=="") {
$SQL="select * from $RISTORANTI where flagbannerna200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
}
if ($PrimoBanner200=="") {
$SQL="select * from $SHOPPING where flagbannerna200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
}
if ($PrimoBanner200=="") {
$SQL="select * from $NAUTICA where flagbannerna200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
}
*/
if ($PrimoBanner200=="") {
$SQL="select * from $BANNER where flagbannerna200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
}
$VISBANNER200="S"; if ($PrimoBanner200=="") { $VISBANNER200="N"; }
/*
$SQL="select * from $HOTEL where flagbannerho341='S' limit 1";
$PrimoHotel341=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner341=$PrimoHotel341[filebanner341];
if ($PrimoBanner341=="") {
$SQL="select * from $RISTORANTI where flagbannerho341='S' limit 1";
$PrimoHotel341=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner341=$PrimoHotel341[filebanner341];
}
if ($PrimoBanner341=="") {
$SQL="select * from $SHOPPING where flagbannerho341='S' limit 1";
$PrimoHotel341=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner341=$PrimoHotel341[filebanner341];
}
if ($PrimoBanner341=="") {
$SQL="select * from $NAUTICA where flagbannerho341='S' limit 1";
$PrimoHotel341=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner341=$PrimoHotel341[filebanner341];
}
*/
if ($PrimoBanner341=="") {
$SQL="select * from $BANNER where flagbannerho341='S' limit 1";
$PrimoHotel341=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner341=$PrimoHotel341[filebanner341];
}
$VISBANNER341="S"; if ($PrimoBanner341=="") { $VISBANNER341="N"; }
?>
Porto Venere/ Nautical Services/Underwater immersions
if ($IDNAU=="") { $IDNAU=0; }
switch ($IDNAU) {
case 0: $DESNAU="Nautical Services"; $FOTO="foto_nautica.jpg"; break;
case 1: $DESNAU="Underwater immersions"; $FOTO="immersioni.jpg"; break;
case 2: $DESNAU="Moorings"; $FOTO="ormeggi.jpg"; break;
case 3: $DESNAU="Excursion in boat"; $FOTO="gite.jpg"; break;
case 4: $DESNAU="Chartering boats, to motor, canoes and pedalo'"; $FOTO="nautica1.jpg"; break;
case 5: $DESNAU="Schools of sail"; $FOTO="vela.jpg"; break;
}
?>