$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; ?>
while ($trip = @mysql_fetch_array($tripData)):
// Select Travellers
$selectTravellers = "select pe.fID, pe.fName as Name, trpe.fID, trpe.frTripID, trpe.frPeopleID, count(trpe.frPeopleID)
from kfmPeople pe
inner join kfmTripPeople trpe on trpe.frPeopleID = pe.fID
where trpe.frTripID = ".$trip["tripID"]."
group by pe.fID
order by pe.fName";
$travellersData = @mysql_query($selectTravellers, $dbh);
$countTravellers = "select count(frPeopleID)
from kfmTripPeople
where frTripID = ".$trip["tripID"];
$countTravellersData = @mysql_query($countTravellers, $dbh);
$travellersNR = @mysql_result($countTravellersData, 0, 0);
// Select Foto
$selectFoto = "select fID, fFilename
from kfmFoto
where fID = ".$trip["fotoID"];
$fotoData = @mysql_query($selectFoto, $dbh);
$foto = @mysql_result($fotoData, 0, 1);
?>
if ($foto != ""): ?>
endif; ?>
style="width:100%;" endif; ?>>
bis
Long else: ?>Start endif; ?>">
les'n
endwhile; ?>