Gerealiseerde projecten

\n"; $rij=0; $link = new mysql; $link->mysql_open(); $result = $link->mysql_do_query("SELECT * FROM ".$table_prefix."projecten WHERE (online < now() AND offline > now()) AND status='gerealiseerd' ORDER BY online DESC, id"); $link->mysql_close(); echo "\n"; echo "\n"; for($i=0;$i\n"; echo "\n"; } echo "\n"; echo "\n"; $rij=$rij+1; if($rij=="3") { echo "\n"; echo "\n"; $rij=0; } } #echo "\n"; echo "

	\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo " \n"; $link = new mysql; $link->mysql_open(); $jpg = $link->mysql_do_query("SELECT * FROM ".$table_prefix."media WHERE id_ref=".$result[$i]['id']." AND type_ref='projecten' AND (type='image/pjpeg' OR type='image/jpeg') LIMIT 0,1"); $link->mysql_close(); if(count($jpg)>0) { for($j=0;$j\n"; } } echo " \n"; echo "".$result[$i]['project']."\n"; echo " \n"; echo "

\n"; echo "

\n"; } else { $link = new mysql; $link->mysql_open(); $result = $link->mysql_do_query("SELECT * FROM ".$table_prefix."projecten WHERE (online < now() AND offline > now()) AND id=".$_REQUEST["id"]." "); $link->mysql_close(); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo "Gerealiseerde projecten "; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; #echo "\n"; #echo "\n"; #echo "\n"; #echo "\n"; #echo "\n"; #echo "\n"; if($result[0]['url']!=NULL) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo " Project  :  ".$result[0]['project']." Locatie  :  ".$result[0]['locatie']." Opdrachtgever  :  ".$result[0]['opdrachtgever']." Omvang  :  ".str_replace("m2","m2",$result[0]['omvang'])." Architect  :  ".$result[0]['architect']." Realisatie  :  ".$result[0]['realisatie']." Website  :  ".$result[0]['url']." terug naar overzicht » \n"; echo "

\n"; ############################################################################################################### $link = new mysql; $link->mysql_open(); $jpg = $link->mysql_do_query("SELECT * FROM ".$table_prefix."media WHERE id_ref='".$_REQUEST["id"]."' AND type_ref='projecten' AND (type='image/pjpeg' OR type='image/jpeg') ORDER BY id"); echo "\n"; $rij = 0; for ($i=0;$i\n"; } echo "\n"; $rij = $rij + 1; if($rij == 2) { echo "\n"; $rij = 0; } } echo " \n"; media($jpg[$i]['id'],1024,"left",'',0,0,0,$jpg[$i]['id']); echo "".media($jpg[$i]['id'],120,"left",'',0,0,0,$jpg[$i]['id'])."\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; #echo ""; ############################################################################################################### echo "

\n"; } include("inc.footer.php"); ?>