$selectFotos = "select fo.fID, fo.fFilename, fo.frDayID, fo.fStartID as StartID, dare.frDayID, dare.frReportID, re.fID, re.fStatusID
from kfmFoto fo
left outer join kfmDayReport dare on dare.frDayID = fo.frDayID
left outer join kfmReport re on re.fID = dare.frReportID
where re.fStatusID = ".$statusID." and fo.fStartID = 1
order by rand()";
$fotosData = @mysql_query($selectFotos, $dbh);
$fotoID = @mysql_result($fotosData, 0, 0);
$foto = @mysql_result($fotosData, 0, 1);
// Select photo details
$selectFotos = "select fo.fID, fo.frDayID, dare.frTripID, dare.frDayID, trde.fID, trde.fTripTitle, da.fID, date_format(da.fDate, '%Y')
from kfmFoto fo
left outer join kfmDayReport dare on dare.frDayID = fo.frDayID
left outer join kfmDay da on da.fID = fo.frDayID
inner join kfmTripDetails trde on trde.fID = dare.frTripID
where fo.fID = ".$fotoID;
$fotosData = @mysql_query($selectFotos, $dbh);
$tripID = @mysql_result($fotosData, 0, 2);
$tripTitle = @mysql_result($fotosData, 0, 5);
$tripDate = @mysql_result($fotosData, 0, 7);
?>
if ($foto != ""): ?>
![,]()
else: ?>

endif; ?>
Willkommen!
Hier findest du Erzählungen und unzählige Fotos von einem Haufen reisewütiger Leute, die mit allergrößter Begeisterung unsere wunderbare Erde bereisen. Alle unsere Reiseberichte sind hier.
Immer auf dem laufenden bleiben kannst du mit unserem RSS Feed. 
News
$i = -1;
while ($news = @mysql_fetch_array($newsData)):
$i++;
// Select Author
$selectAuthor = "select pe.fID, pe.fName as Name, ne.fID, ne.frAuthorID
from kfmPeople pe
inner join kfmNews ne on ne.frAuthorID = pe.fID
where ne.fID = ".$news["newsID"]."
group by pe.fID";
$authorData = @mysql_query($selectAuthor, $dbh);
$author = @mysql_result($authorData, 0, 1);
// Check for News Details
if ($news["Text"] != "") {
$detail = "";
}
else {
$detail = "";
$detailEnd = "";
}
// Check for Trip
if (($news["TripTitle"] != "") && ($news["TripStatus"] == 1)) {
$tripTitle = "
".$news["TripTitle"]."";
}
elseif (($news["TripTitle"] != "") && ($news["TripStatus"] == 0)) {
$tripTitle = "
".$news["TripTitle"]."";
}
else {
$tripTitle = "Allgemein";
}
?>
if ($news["Foto"] != "0"): ?>
endif; ?>
style="width:100%;" endif; ?>>
//
von
if ($news["Text"] != ""): ?>
endif; ?>
endwhile; ?>