Home / Reizen / Reisdetails

 

reizen
 
 
=now() GROUP BY a.id ORDER BY b.datum_van ASC LIMIT 1"; } else { $sql = "SELECT a.* FROM reizen AS a LEFT JOIN reizen_data AS b ON b.reis_id = a.id LEFT JOIN reizen_operators AS c ON b.operator_id = c.id WHERE b.datum_tot>=now() GROUP BY a.id ORDER BY b.datum_van ASC LIMIT 1"; } $result = mysql_query($sql) or die("Kan query niet uitvoeren"); $row = mysql_fetch_array($result); if ($row) { $subdata = "Terug naar reisoverzicht
"; echo "

".$row["titel"]."

".$row["inleiding"]."

".changeBold($row["hoofdtekst"])."

"; $isql = "SELECT b.id, b.extra_titel, b.datum_van, b.datum_tot, b.apart_programma, b.apart_info_en_reserveren, c.id AS cid, c.naam, c.omschrijving, c.website, c.telefoon, c.email FROM reizen_data AS b LEFT JOIN reizen_operators AS c ON b.operator_id = c.id WHERE b.reis_id = ".gval("id")." AND b.datum_tot>=now() ORDER BY b.datum_van ASC"; $iresult = mysql_query($isql) or die("Kan query niet uitvoeren"); echo "

Data

"; $subdata.= "Data"; $oldreis = ""; $endsubdata = ""; $enddata = ""; while ($irow = mysql_fetch_array($iresult)) { echo ndate($irow["datum_van"], "j F Y")." - ".ndate($irow["datum_tot"], "j F Y")." ".$irow["extra_titel"]."
"; if ($irow["naam"]!="" && $oldreis!=$irow["naam"]) { $oldreis=$irow["naam"]; $endsubdata = "Reisoperator(s)"; $enddata.="

Reisoperator

".$irow["naam"]."

".$irow["omschrijving"]."

Website: ".str_replace("http://","",trim($irow["website"],"/"))."
Telefoon: ".$irow["telefoon"]."
E-mail: ".str_replace("http://","",trim($irow["email"],"/"))."

"; } } mysql_free_result($iresult); echo "
"; if ($row["programma"]!="") { $subdata.= "Programma"; echo "

Programma

".changeBold($row["programma"])."
"; } if ($row["info_en_reserveren"]!="") { $subdata.= "Info & Reserveren"; echo "

Info & Reserveren

".changeBold($row["info_en_reserveren"])."
"; } if ($enddata!="") { $subdata.=$endsubdata; echo $enddata; } // \"reis\"
".$row["titel"]."


Van ".ndate($row["dedatum"], "j F Y")." tot ".ndate($row["datum_tot"], "j F Y")." via ".$row["naam"]."."; $reisid = $row["id"]; } mysql_free_result($result); ?>
\"reis\"

".$subdata; echo $subdata; ?>

 

   
   

Steun Stichting 1Ouder: bankrekeningnummer 341631892 o.v.v. donatie