";
echo "| ";
echo " ";
echo "";
echo "";
echo "Die Yacht";
echo "";
echo "";
echo "
";
echo "";
echo "Bilder der Yacht";
echo "
";
echo "Der Skipper";
echo "
";
echo "Bedingungen";
echo "";
echo "";
echo "
";
echo "Mitsegeln";
echo "";
echo "";
echo "
";
echo "Reiseroute";
echo "
";
echo "";
echo "";
echo "";
echo "";
echo "w";
echo "Mittelmeer";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "w";
echo "Rotes Meer";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "w";
echo "Indischer Ozean";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "w";
echo "Indien";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "w";
echo "Golf von Bengalen";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "w";
echo "Thailand";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "w";
echo "Myanmar";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "w";
echo "Malakka Strait";
echo "";
echo "";
echo " ";
echo "";
echo "";
echo "w";
echo "Suedchinesisches Meer";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "w";
echo "Philippinen";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "";
echo "w";
echo "Nordpazifik - Guam";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "";
echo "w";
echo "Nordpazifik - Karolinen";
echo "";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "";
echo "w";
echo "Und weiter";
echo "";
echo "";
echo "";
echo "
";
echo "";
echo "Anmeldung";
echo "
";
echo "";
echo "Gaestebuch";
echo "
";
echo "Ferienfotos";
//echo "
";
echo "";
echo "
";
echo "Kochrezepte";
echo "";
echo "";
echo "";
echo "";
echo "
";
echo "";
echo "";
echo "";
echo " ";
echo " | ";
echo "";
echo "";
echo "";
echo " | ";
echo "";
include 'main.php';
mysql_connect( "$host", "$user", "$pw");
$result = mysql_select_db( "$db") or die ( "Unable to select database.");
//Alle felder aus der Tabelle daten1 auswählen, wo die Kundennummer übereinstimmt, mit der anmeldung
$result = mysql_query("select * from $tabelle where anzeigen='ja'");
$row = mysql_num_rows($result);
$ROW_PER_PAGE = 1;
$rel = mysql_query("select * from $tabelle where anzeigen ='ja'order by id ASC");
$MAX_ROW = mysql_num_rows($rel);
if (isset($BUTTON))
{
$EXTEND = "limit $LOWER_ROW";
}
else
{
$BUTTON = Beginn;
$TMP_NUM = 0 ;
}
switch ($BUTTON)
{
case Beginn:
$TMP_NUM = 0 ;
$EXTEND = "limit $ROW_PER_PAGE ";
break;
case Ende:
$TMP_NUM = $MAX_ROW - $MAX_ROW % $ROW_PER_PAGE;
$LOWER_ROW = $TMP_NUM ;
if ($LOWER_ROW == $MAX_ROW && $LOWER_ROW != 0)
{
$LOWER_ROW = $MAX_ROW - $ROW_PER_PAGE;
$TMP_NUM = $TMP_NUM - $ROW_PER_PAGE;
}
$EXTEND = "limit $LOWER_ROW, $ROW_PER_PAGE";
break;
case Prev:
$TMP_NUM = $CURVALUE - $ROW_PER_PAGE;
if ($TMP_NUM < 0)
{
$TMP_NUM = 0;
$LOWER_ROW = 0;
}
else
{
$LOWER_ROW = $TMP_NUM;
}
$EXTEND = "limit $LOWER_ROW, $ROW_PER_PAGE";
break;
case Next:
if (($CURVALUE + $ROW_PER_PAGE) < $MAX_ROW )
{
$LOWER_ROW = $CURVALUE + $ROW_PER_PAGE;
}
else
{
$LOWER_ROW = $CURVALUE;
}
$TMP_NUM = $LOWER_ROW;
$EXTEND = "limit $LOWER_ROW, $ROW_PER_PAGE";
break;
}
if ($EXTENDD != '')
{
$EXTEND=$EXTENDD;
}
if ($CURVALUEE != '')
{
$CURVALUE=$CURVALUEE;
}
if ($TMP_NUMM != '')
{
$TMP_NUM = $TMP_NUMM;
}
//Abfrage des Feldes thumbnaily zur Überprüfung der Höhe des thumbnails und eventuell korrigieren
$y = '75';
// $result = mysql_select_db( "$db") or die ( "Unable to select database.");
$result = mysql_query ( "select thumbnaily from daten where thumbnaily != '' ");
while ($row = mysql_fetch_row($result))
{
if ($row[0] > $y )
{
$y = $row[0];
}
}
//auswählen der wichtigsten1 Felder für die browse-Ansicht um einen überblick zu gewinnen
$result = mysql_query ( "select thumbnail, thumbnailxy, thumbnailname, id, anzeigen, bildtitel, bild, bildxy, bildname, bildbeschreibung from $tabelle where anzeigen='ja' order by id ASC $EXTEND ");
// fetch the rows one at atime, and then echo the data to the page
$anzahl=$TMP_NUM;
$anzahl=$anzahl+ $ROW_PER_PAGE;
echo "";
echo "";
echo " | ";
echo " ";
echo "";
echo "";
echo "![Anfang](\"images/anf.gif\") ";
echo "![Zurück](\"images/zur.gif\") ";
echo "![Vorwärts](\"images/vor.gif\") ";
echo "![Ende](\"images/end.gif\") ";
echo " | ";
echo " ";
echo "";
if ($anzahl>$MAX_ROW)
{
echo "| ";
echo "";
echo "";
if ($MAX_ROW == 0)
{
echo "Zur Zeit gibt es noch keine Fotos und Berichte von der Weltumsegelung.";
}else
{
echo "Teil $MAX_ROW von $MAX_ROW";
}
echo "";
echo "";
echo " | ";
}else
{
echo "";
echo "";
echo "";
echo "Teil $anzahl von $MAX_ROW";
echo "";
echo "";
echo " | ";
}
echo " ";
echo " ";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "";
echo " [1] ";
echo "[2] ";
echo "[3] ";
echo "[4] ";
echo "[5] ";
echo "[6] ";
echo "[7] ";
echo "[8] ";
echo "[9] ";
echo "[10] ";
echo "[11] ";
echo "[12] ";
echo "[13] ";
echo "[14] ";
echo "[15] ";
echo "[16] ";
echo "[17] ";
echo "[18] ";
echo "[19] ";
echo "[20] ";
echo "[21] ";
echo "";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "";
echo " [22] ";
echo "[23] ";
echo "[24] ";
echo "[25] ";
echo "[26] ";
echo "[27] ";
echo "[28] ";
echo "[29] ";
echo "[30] ";
echo "[31] ";
echo "[32] ";
echo "[33] ";
echo "[34] ";
echo "[35] ";
echo "[36] ";
echo "[37] ";
echo "[38] ";
echo "[39] ";
echo "[40] ";
echo "";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "";
echo " [41] ";
echo "[42] ";
echo "[43] ";
echo "[44] ";
echo "[45] ";
echo "[46] ";
echo "[47] ";
echo "[48] ";
echo "[49] ";
echo "[50] ";
echo "[51] ";
echo "[52] ";
echo "[53] ";
echo "[54] ";
echo "[55] ";
echo "[56] ";
echo "[57] ";
echo "[58] ";
echo "";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "";
echo "";
while ($row = mysql_fetch_row($result))
{
if ($row[4] == 'ja')
{
//Variablenzuweisung für die übergabe an die details.php
$id=$row[3];
echo "";
echo "";
echo "";
echo "| ";
echo " | ";
echo " ";
echo "";
echo "";
echo "";
echo "";
echo "| ";
echo " | ";
echo " ";
echo "";
echo "";
//echo "";
echo "";
if ($row[5] != '')
{
echo "";
echo "| ";
echo "";
echo "";
echo nl2br(htmlentities($row[5]));
echo "";
echo "";
echo " | ";
echo " ";
}
echo "";
echo "";
//Überprüfung, ob thumbnail vorhanden und anzeigen
if ( $row[0] != '')
{
if ($bild == 0)
{
echo "![\" \"](\"images/dummy_pixel.gif\") ![](\"/bericht/$row[0]\"";) ";
}
if ($bild == 1)
{
echo "![](\"/bericht/$row[6]\"";) ";
}
}
else
{
//echo " ";
echo "";
}
echo " | ";
echo " ";
if ($row[9] != '')
{
echo "";
echo "| | ";
echo " ";
echo "";
echo "";
echo "";
echo "";
echo "| ";
echo "";
echo "";
echo nl2br(htmlentities($row[9]));
echo "";
echo "";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
}
echo " ";
echo "";
echo "";
echo " ";
echo " | ";
echo " ";
if ($row[9] != '')
{
echo "";
echo "| ";
echo " | ";
echo " ";
}
echo " ";
echo " | ";
echo " ";
}
}
echo "";
echo " ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
echo " ";
echo "";
echo " | ";
echo "
";
echo "![\"wpe5.jpg](\"../_borders/linsen1.jpg\")
";
echo "![\"wpe6.jpg](\"../_borders/linsen2.jpg\")
";
echo "