include ("portovenere.inc");
$PVE=mysql_connect ("$PVEOST","$PVESER","$PVEASS");
$SQL="select * from $HOTEL where flagbannersh100='S' limit 1";
/*
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
if ($PrimoBanner100=="") {
$SQL="select * from $RISTORANTI where flagbannersh100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
}
if ($PrimoBanner100=="") {
$SQL="select * from $SHOPPING where flagbannersh100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
}
if ($PrimoBanner100=="") {
$SQL="select * from $NAUTICA where flagbannersh100='S' limit 1";
$PrimoHotel100=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner100=$PrimoHotel100[filebanner];
}
*/
if ($PrimoBanner100=="") {
$SQL="select * from $BANNER where flagbannersh100='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 flagbannersh200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
if ($PrimoBanner200=="") {
$SQL="select * from $RISTORANTI where flagbannersh200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
}
if ($PrimoBanner200=="") {
$SQL="select * from $SHOPPING where flagbannersh200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
}
if ($PrimoBanner200=="") {
$SQL="select * from $NAUTICA where flagbannersh200='S' limit 1";
$PrimoHotel200=mysql_fetch_array(mysql_query($SQL,$PVE));
$PrimoBanner200=$PrimoHotel200[filebanner200];
}
*/
if ($PrimoBanner200=="") {
$SQL="select * from $BANNER where flagbannersh200='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"; }
?>
Portovenere/home page
if ($IDSHO=="") { $IDSHO=0; }
switch ($IDSHO) {
case 0: $DESSHO="Shopping Advice"; $FOTO="collage_negozi.jpg"; break;
case 1: $DESSHO="Kunstgewerbe"; $FOTO="artigianato.jpg"; break;
case 2: $DESSHO="Lebensmittel"; $FOTO="gastronomia2.jpg"; break;
case 3: $DESSHO="Unterschiedliches"; $FOTO="negozi.jpg"; break;
}
?>
|
|
if ($VISBANNER341=="S") { ?>
|
} ?>
|
|
|
Home
page / Shopping Advice
if ($IDSHO>0) { echo "/ $DESSHO"; } ?>
|
echo strtoupper($DESSHO); ?> |
|
valign="top">
if ($IDSHO==0) { ?>
Kommen und erleben Sie die "carrugi" von Portovenere. Entdecken Sie die malerischen Geschäfte, die lokalen Kunsthandwerke, typische Produkte der einheimischen Küche. Sie werden Kleidung finden die Sie suchen. Schlendern Sie durch die bekannten, antiken Wege, die die Faszination der alten Zeit konservieren. Gute Unterhaltung.
|
} ?>
$SQL="select * from $SHOPPING where idgruppo=$IDSHO order by descrizione";
$RisShopping=mysql_query($SQL,$PVE);
$COLORE="#FFFFFF";
while ($Shopping=mysql_fetch_array($RisShopping)) {
if ($COLORE=="#FFFF99") { $COLORE="#FFFFFF"; } else { $COLORE="#FFFF99"; }
echo "
$Shopping[descrizione] |
$Shopping[indirizzo]";
if ($Shopping[frazione]>"") { echo " $Shopping[frazione]"; }
echo "";
if ($Shopping[telefono1]>"") { echo " Tel. $Shopping[telefono1]"; }
if ($Shopping[telefono2]>"") { echo "-$Shopping[telefono2]"; }
if ($Shopping[cellulare1]>"") { echo " Cel. $Shopping[cellulare1]"; }
if ($Shopping[cellulare2]>"") { echo "-$Shopping[cellulare2]";}
if ($Shopping[sitoweb]>"" or $Shopping[email]>"") { echo " "; }
echo "";
if ($Shopping[sitoweb]>"") {
$DEST="_self";
$LINK="link.php?SITO=$Shopping[sitoweb]";
if ($Shopping[flagweb]=="S") { $DEST="_blank"; $LINK="http://$Shopping[sitoweb]"; }
echo "
  "; }
if ($Shopping[email]>"") {
echo ""; }
echo " | ";
}
?>
|
|
|
|
Ausflugziele /
Hotel, Zimmer mit Frühstück / Nautische Infos
/ Einkaufastipps /
Virtual Porto Venere tour
/ News
/ Restaurant, kaffees und Badeanstalten
/ Elektronische Ansichtskarten
/ Nützliche Telefonnummern
/ Transporte, Mappe u. Gemeindebeschlüsse
|
|