0) $g2="AND groupurl2 LIKE '$groupurl2'"; //if(strlen($groupurl3)>0) $g3="AND groupurl3 LIKE '$groupurl3'"; $pagetitle="Parijs-Frankrijk.nl - Parijs weekend citytrip hotel reis"; $httphost=$_SERVER['HTTP_HOST']; $result = mysql_query("SELECT * FROM content WHERE groupurl1 LIKE '' AND httphost LIKE '$httphost'") or die(mysql_error()); $topresult = mysql_query("SELECT * FROM content WHERE groupurl1 LIKE 'bestemmingen' ORDER BY hits DESC LIMIT 10") or die(mysql_error()); $record = mysql_fetch_object($result); $id=$record->id; $title=$record->title; if(strlen($groupurl3)>0) $grouptitle3=$title; else $grouptitle2=$title; $shorttitle=$record->shorttitle; $righttext=nl2br($record->righttext); $shortdescription=$record->shortdescription; $parenttype=$record->parenttype; $type=$record->type; $hits=$record->hits; $ads=$record->ads; $hits++; mysql_query("UPDATE content SET hits='$hits' WHERE id='$id'") or die(mysql_error()); $keywords=$record->keywords; //$contentsubresult = mysql_query("SELECT * FROM contentsub WHERE contentid='$id' AND visible='1' ORDER BY position") or die(mysql_error()); $contentsubresult = mysql_query("SELECT * FROM contentsub WHERE contentid='$id'") or die(mysql_error()); //$result = mysql_query("SELECT * FROM content WHERE groupurl1 LIKE '$groupurl1' AND (groupurl2 LIKE '$g2' AND type=1) ORDER BY groupurl2,groupurl3") or die(mysql_error()); // de goede! //$bestemmingenresult = mysql_query("SELECT * FROM content WHERE groupurl1 LIKE '$groupurl1' AND groupurl2 LIKE '$g2' ORDER BY groupurl2, groupurl3") or die(mysql_error()); //$bestemmingenresult = mysql_query("SELECT * FROM content WHERE groupurl1 LIKE '' ORDER BY groupurl2, groupurl3") or die(mysql_error()); // mysql_num_rows($result); $tab="home"; $left[0]['url']="links/"; $left[0]['title']="Links"; $left[0][0]['url']="http://www.reislijst.nl/"; $left[0][0]['title']="ReisLijst.nl"; $left[0][1]['url']="http://www.barcelona-spanje.nl/"; $left[0][1]['title']="Barcelona-Spanje.nl"; $left[0][2]['url']="http://www.berlijn-duitsland.nl/"; $left[0][2]['title']="Berlijn-Duitsland.nl"; $left[0][3]['url']="http://www.rhodos-griekenland.nl/"; $left[0][3]['title']="Rhodos-Griekenland.nl"; $left[0][4]['url']="http://www.rome-italie.nl/"; $left[0][4]['title']="Rome-Italie.nl"; $left[0][4]['url']="http://www.ticketvlieg.nl/"; $left[0][4]['title']="Ticketvlieg vliegtickets"; $left[0][5]['url']="links/"; $left[0][5]['title']="meer links..."; // blabla naar eerste $contentsubresult = mysql_query("SELECT * FROM contentsub WHERE contentid='$id' AND visible='1' ORDER BY position") or die(mysql_error()); $alignbool=true; $i=0; while ($contentsub = mysql_fetch_object($contentsubresult)) { $mainContent[$i]['title']=$contentsub->title; $mainContent[$i]['text']=$contentsub->text; $mainContent[$i]['imagefilename']=$contentsub->imagefilename; $mainContent[$i]['imagetitle']=$contentsub->imagetitle; $mainContent[$i]['imagelink']=$contentsub->imagelink; $mainContent[$i]['imagedescription']=$contentsub->imagedescription; $mainContent[$i]['urltitle']=$contentsub->urltitle; $i++; } $aanbiedingenresult = mysql_query("SELECT * FROM traveloffers2 WHERE httphost LIKE '$httphost' ORDER BY price LIMIT 3") or die(mysql_error()); $text=""; while ($contentsub = mysql_fetch_object($aanbiedingenresult)) { // $left[0][$i]['title']= $contentsub->shorttitle; $country=$contentsub->country; $place=$contentsub->place; $image=$contentsub->image; $days=$contentsub->days; $transport=$contentsub->transport; $departdate=strtotime($contentsub->departdate); $description=$contentsub->description; $accomodation=$contentsub->accomodation; $price=$contentsub->price; $url=$contentsub->url; $travelcompany=$contentsub->travelcompany; $persons=$contentsub->persons; // setlocale (LC_ALL, "dutch"); $dagen = array('zondag', 'maandag', 'dinsdag', 'woensdag', 'donderdag', 'vrijdag', 'zaterdag'); $maanden = array('januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december'); $dag=$dagen[date("w",$departdate)]; $dagnr=date("j",$departdate); $maand=$maanden[date("n",$departdate)-1]; $dat=strftime("%A %e %B",$departdate); $text.="

$country - $place

$days dagen - $transport
$accomodation
$description
Vanaf € $price pp bij $travelcompany

"; // if(strlen($location2)>0) // $left[0][$i]['url']="/bestemmingen/$location/$location2/"; // else // $left[0][$i]['url']="/bestemmingen/$location/"; // $i++; } $text.="
Meer aanbiedingen...

"; $mainContent[i]['title']="Aanbiedingen"; $mainContent[i]['text']=$text; mysql_close($sqlconnection); include "layout.php"; ?>