0)) {
$start = 0;
}
// No of records to be shown per page.
$eu = ($start -0);
$limit = 1000;
$this1 = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
// We have to find out the number of records in our table to break the pages
$query2="select da.fID as dayID, date_format(da.fDate, '%Y-%m-%d') as dayDate, re.fID as reportID, re.fTitle as DayTitle, re.fPreface as DayPreface, re.fText as Text, re.frAuthorID as authorID, re.frLanguageID as languageID, re.fMainID as mainID, re.fStatusID as statusID, dare.frTripID, dare.frDayID, dare.frReportID, dare.frFotoID, fo.fID, fo.fFilename as Foto, la.fID, la.fShort
from kfmDay da
inner join kfmDayReport dare on dare.frDayID = da.fID
inner join kfmReport re on re.fID = dare.frReportID
left outer join kfmFoto fo on fo.fID = dare.frFotoID
inner join comLanguage la on la.fID = re.frLanguageID
where re.frLanguageID = 1 and re.fStatusID = ".$statusID." and dare.frTripID = ".$tripID."
group by re.fID
order by da.fDate
asc";
$result2=mysql_query($query2);
echo mysql_error();
$nume=mysql_num_rows($result2);
// Now let us start executing the query with variables $eu and $limit set at the top of the page
$query="select da.fID as dayID, date_format(da.fDate, '%d.%m.%Y') as dayDate, re.fID as reportID, re.fTitle as DayTitle, re.fPreface as DayPreface, re.fText as Text, re.frAuthorID as authorID, re.frLanguageID as languageID, re.fMainID as mainID, re.fStatusID as statusID, dare.frTripID, dare.frDayID, dare.frReportID, dare.frFotoID, fo.fID, fo.fFilename as Foto, la.fID, la.fShort, de.fID, de.fTripTitle as TripTitle, trda.frTripID, trda.frTripDetailsID
from kfmDay da
inner join kfmDayReport dare on dare.frDayID = da.fID
inner join kfmReport re on re.fID = dare.frReportID
left outer join kfmFoto fo on fo.fID = dare.frFotoID
inner join comLanguage la on la.fID = re.frLanguageID
inner join kfmTripData trda on trda.frTripID = dare.frTripID
inner join kfmTripDetails de on de.fID = trda.frTripID
where re.frLanguageID = 1 and re.fStatusID = ".$statusID." and dare.frTripID = ".$tripID."
group by re.fID
order by da.fDate
asc
limit $eu, $limit";
$result=mysql_query($query);
echo mysql_error();
// Get TripInfo
$selectTripInfo = "select tr.fID, date_format(tr.fTripFrom, '%d.%m.%Y'), date_format(tr.fTripTo, '%d.%m.%Y'), de.fID, de.fTripTitle, de.fStatusID, de.frLanguageID, trda.frTripID, trda.frTripDetailsID, de.fTripTeaser
from kfmTrip tr
inner join kfmTripData trda on trda.frTripID = tr.fID
inner join kfmTripDetails de on de.fID = trda.frTripDetailsID
where de.frLanguageID = 1 and de.fStatusID = ".$statusID." and tr.fID = ".$tripID."
group by tr.fID";
$tripInfoData = @mysql_query($selectTripInfo, $dbh);
$tripFrom = @mysql_result($tripInfoData, 0, 1);
$tripTo = @mysql_result($tripInfoData, 0, 2);
$tripTitle = @mysql_result($tripInfoData, 0, 4);
$tripTeaser = @mysql_result($tripInfoData, 0, 9);
// 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 = ".$tripID."
group by pe.fID
order by pe.fName";
$travellersData = @mysql_query($selectTravellers, $dbh);
$countTravellers = "select count(frPeopleID)
from kfmTripPeople
where frTripID = ".$tripID;
$countTravellersData = @mysql_query($countTravellers, $dbh);
$travellersNR = @mysql_result($countTravellersData, 0, 0);
// Select Startpicture
$selectFotos = "select fo.fID, fo.fFilename, fo.frDayID, fo.fStartID, dare.frDayID, dare.frTripID, dare.frReportID, re.fID, re.fStatusID
from kfmFoto fo
inner join kfmDayReport dare on dare.frDayID = fo.frDayID
left outer join kfmReport re on re.fID = dare.frReportID
where re.fStatusID = ".$statusID." and dare.frTripID = ".$tripID."
order by rand()";
$fotosData = @mysql_query($selectFotos, $dbh);
$foto = @mysql_result($fotosData, 0, 1);
// Variables set for advance paging
// This should be more than $limit and set to a value for which links to be breaked
$p_limit=800;
// To take care global variable if OFF
$p_f=$_GET['p_f'];
// This variable is set to zero for the first page
if(!($p_f > 0)) {
$p_f = 0;
}
$p_fwd=$p_f+$p_limit;
$p_back=$p_f-$p_limit;
?>
Komm flieg mit // The trip begins here
