// woning pagina // ================ if($_GET['page'] == "woning" && $rowinstellingen['makelaar'] == 'ja'){ //op page woning haal de eerste foto op van de woning ipv de hoofdtoto van de normale gallerij $pandsocialmedia = $mysqli->query("SELECT id FROM sitework_woonhuizen WHERE paginaurl = '" . $_GET['title'] . "'") or die($mysqli->error . __LINE__); $rowpandsocial = $pandsocialmedia->fetch_assoc(); $sqlimgsocial = $mysqli->query("SELECT lokaalurl FROM sitework_media WHERE woonhuizen_id = '".$rowpandsocial['id']."' order by volgorde ASC LIMIT 1") or die($mysqli->error.__LINE__); $rowimgsocial = $sqlimgsocial->fetch_assoc(); $socialimage = $url."/woningen/img/".$rowimgsocial['lokaalurl']; // bedrijfspand pagina // =================== } elseif($_GET['page'] == "bedrijfspand" && $rowinstellingen['makelaar'] == 'ja' && $rowinstellingen['bogaanbod']){ //op page woning haal de eerste foto op van de woning ipv de hoofdtoto van de normale gallerij $pandsocialmedia = $mysqli->query("SELECT id FROM sitework_objecten WHERE paginaurl = '" . $_GET['title'] . "'") or die($mysqli->error . __LINE__); $rowpandsocial = $pandsocialmedia->fetch_assoc(); $sqlimgsocial = $mysqli->query("SELECT lokaalurl FROM sitework_mediabog WHERE object_id = '".$rowpandsocial['id']."' order by volgorde ASC LIMIT 1") or die($mysqli->error.__LINE__); $rowimgsocial = $sqlimgsocial->fetch_assoc(); $socialimage = $url."/realworks_bog/img/".$rowimgsocial['lokaalurl']; // normale pagina // ============== } else { $sqlimgsocial = $mysqli->query("SELECT * FROM sitework_img WHERE cms_id = '".$row['id']."' order by volgorde ASC LIMIT 1") or die($mysqli->error.__LINE__); $rowimgsocial = $sqlimgsocial->fetch_assoc(); $socialimage = $url."/img/".$rowimgsocial['naam'].".jpg"; } ?>