[{"0":"jbace-huisstijl","post_name":"jbace-huisstijl","1":"160","ID":"160","cat_id":"3","cat_name":"huisstijlen","cat_slug":"huisstijl"},{"0":"svoz-huisstijl","post_name":"svoz-huisstijl","1":"185","ID":"185","cat_id":"3","cat_name":"huisstijlen","cat_slug":"huisstijl"},{"0":"eervol-com-huisstijl","post_name":"eervol-com-huisstijl","1":"386","ID":"386","cat_id":"3","cat_name":"huisstijlen","cat_slug":"huisstijl"},{"0":"roel-huisstijl","post_name":"roel-huisstijl","1":"390","ID":"390","cat_id":"3","cat_name":"huisstijlen","cat_slug":"huisstijl"},{"0":"goedwerkhub-huisstijl","post_name":"goedwerkhub-huisstijl","1":"395","ID":"395","cat_id":"3","cat_name":"huisstijlen","cat_slug":"huisstijl"},{"0":"recreatie-midden-nederland-huisstijl","post_name":"recreatie-midden-nederland-huisstijl","1":"425","ID":"425","cat_id":"3","cat_name":"huisstijlen","cat_slug":"huisstijl"},{"0":"enkeltje-toekomst","post_name":"enkeltje-toekomst","1":"195","ID":"195","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"mitros-stenen","post_name":"mitros-stenen","1":"198","ID":"198","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"nationaal-geschenk","post_name":"nationaal-geschenk","1":"201","ID":"201","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"shn-goed-recht","post_name":"shn-goed-recht","1":"204","ID":"204","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"stadspleinen-utrecht","post_name":"stadspleinen-utrecht","1":"208","ID":"208","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"talis-schoon","post_name":"talis-schoon","1":"404","ID":"404","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"drukkerij-libertas-ode-aan-creatief-utrecht","post_name":"drukkerij-libertas-ode-aan-creatief-utrecht","1":"1111","ID":"1111","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"slachtofferhulp-nederland-stichting-impact-en-echoes-online-herdenkingsboek","post_name":"slachtofferhulp-nederland-stichting-impact-en-echoes-online-herdenkingsboek","1":"1124","ID":"1124","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"vilans-interviewbundel","post_name":"vilans-interviewbundel","1":"1161","ID":"1161","cat_id":"4","cat_name":"boeken","cat_slug":"boeken"},{"0":"ggz-jaarverslag","post_name":"ggz-jaarverslag","1":"399","ID":"399","cat_id":"11","cat_name":"jaarverslagen","cat_slug":"jaarverslagen"},{"0":"vso-jaarverslag","post_name":"vso-jaarverslag","1":"408","ID":"408","cat_id":"11","cat_name":"jaarverslagen","cat_slug":"jaarverslagen"},{"0":"mee-gelderse-poort-jaarplan-2010","post_name":"mee-gelderse-poort-jaarplan-2010","1":"846","ID":"846","cat_id":"11","cat_name":"jaarverslagen","cat_slug":"jaarverslagen"},{"0":"centrum-indicatiestelling-zorg-online-jaarbericht","post_name":"centrum-indicatiestelling-zorg-online-jaarbericht","1":"1215","ID":"1215","cat_id":"11","cat_name":"jaarverslagen","cat_slug":"jaarverslagen"},{"0":"stijl6-flyer","post_name":"stijl6-flyer","1":"434","ID":"434","cat_id":"5","cat_name":"projectcommunicatie \/ campagnes","cat_slug":"projectcommunicatie-campagnes"},{"0":"talis-postkantoor-advertentie","post_name":"talis-postkantoor-advertentie","1":"443","ID":"443","cat_id":"5","cat_name":"projectcommunicatie \/ campagnes","cat_slug":"projectcommunicatie-campagnes"},{"0":"vhto-talentenkijker","post_name":"vhto-talentenkijker","1":"1050","ID":"1050","cat_id":"5","cat_name":"projectcommunicatie \/ campagnes","cat_slug":"projectcommunicatie-campagnes"},{"0":"vso-en-randstad-wervingsactie","post_name":"vso-en-randstad-wervingsactie","1":"1083","ID":"1083","cat_id":"5","cat_name":"projectcommunicatie \/ campagnes","cat_slug":"projectcommunicatie-campagnes"},{"0":"vhto-shoppen-voor-je-toekomst-2","post_name":"vhto-shoppen-voor-je-toekomst-2","1":"1204","ID":"1204","cat_id":"5","cat_name":"projectcommunicatie \/ campagnes","cat_slug":"projectcommunicatie-campagnes"},{"0":"ciz-opleidingengids","post_name":"ciz-opleidingengids","1":"211","ID":"211","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"kunstuitleen-utrecht","post_name":"kunstuitleen-utrecht","1":"220","ID":"220","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"np-folder","post_name":"np-folder","1":"223","ID":"223","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"ocw-stage","post_name":"ocw-stage","1":"226","ID":"226","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"ocw-inkomstennormen","post_name":"ocw-inkomstennormen","1":"230","ID":"230","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"ocw-digitalisering","post_name":"ocw-digitalisering","1":"233","ID":"233","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"ocw-tijdelijk-gebruik","post_name":"ocw-tijdelijk-gebruik","1":"236","ID":"236","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"vhto-speeddaten","post_name":"vhto-speeddaten","1":"242","ID":"242","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"vhto-spiegelbeeld-speeddaten","post_name":"vhto-spiegelbeeld-speeddaten","1":"246","ID":"246","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"talis-brochure-2","post_name":"talis-brochure-2","1":"340","ID":"340","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"uvh-corporate-brochure","post_name":"uvh-corporate-brochure","1":"870","ID":"870","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"sting-ambassadeursgidsje","post_name":"sting-ambassadeursgidsje","1":"904","ID":"904","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"sting-werkboek-vraaggerichte-zorg","post_name":"sting-werkboek-vraaggerichte-zorg","1":"919","ID":"919","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"centrum-voor-jeugd-en-gezin-amersfoort-basisschoolleerlingen","post_name":"centrum-voor-jeugd-en-gezin-amersfoort-basisschoolleerlingen","1":"1219","ID":"1219","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"vhto-meisjes-aan-zet","post_name":"vhto-meisjes-aan-zet","1":"1252","ID":"1252","cat_id":"6","cat_name":"brochures \/ folders","cat_slug":"brochures-folders"},{"0":"cogiscope-2","post_name":"cogiscope-2","1":"250","ID":"250","cat_id":"7","cat_name":"tijdschriften","cat_slug":"tijdschriften"},{"0":"stadium","post_name":"stadium","1":"254","ID":"254","cat_id":"7","cat_name":"tijdschriften","cat_slug":"tijdschriften"},{"0":"vhto-zien-doen-gaan","post_name":"vhto-zien-doen-gaan","1":"257","ID":"257","cat_id":"7","cat_name":"tijdschriften","cat_slug":"tijdschriften"},{"0":"vso-nieuws-2","post_name":"vso-nieuws-2","1":"261","ID":"261","cat_id":"7","cat_name":"tijdschriften","cat_slug":"tijdschriften"},{"0":"sting-nieuws","post_name":"sting-nieuws","1":"320","ID":"320","cat_id":"7","cat_name":"tijdschriften","cat_slug":"tijdschriften"},{"0":"verzekeringsunie-magazine","post_name":"verzekeringsunie-magazine","1":"851","ID":"851","cat_id":"7","cat_name":"tijdschriften","cat_slug":"tijdschriften"},{"0":"vilans-sandra-en-siona","post_name":"vilans-sandra-en-siona","1":"1053","ID":"1053","cat_id":"7","cat_name":"tijdschriften","cat_slug":"tijdschriften"},{"0":"de-vernieuwde-stad-website-2","post_name":"de-vernieuwde-stad-website-2","1":"273","ID":"273","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"eervol-website","post_name":"eervol-website","1":"281","ID":"281","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"marktmeesters-website","post_name":"marktmeesters-website","1":"284","ID":"284","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"slachtofferhulp-website","post_name":"slachtofferhulp-website","1":"287","ID":"287","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"verweij-bouwtechniek-b-v-website","post_name":"verweij-bouwtechniek-b-v-website","1":"290","ID":"290","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"cjg-e-book","post_name":"cjg-e-book","1":"413","ID":"413","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"talis-eigen-huis-website","post_name":"talis-eigen-huis-website","1":"416","ID":"416","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"mitros-website","post_name":"mitros-website","1":"419","ID":"419","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"victim-support-europe-website","post_name":"victim-support-europe-website","1":"841","ID":"841","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"mitros-website-de-pionier","post_name":"mitros-website-de-pionier","1":"971","ID":"971","cat_id":"8","cat_name":"digitale media","cat_slug":"digitale-media"},{"0":"coach-co","post_name":"coach-co","1":"298","ID":"298","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"gemeente-den-haag","post_name":"gemeente-den-haag","1":"301","ID":"301","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"senternovem","post_name":"senternovem","1":"305","ID":"305","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"talis-schuttingkaart","post_name":"talis-schuttingkaart","1":"314","ID":"314","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"slachtofferhulp-iconen","post_name":"slachtofferhulp-iconen","1":"422","ID":"422","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"marokkaanse-antilliaanse-tafels","post_name":"marokkaanse-antilliaanse-tafels","1":"438","ID":"438","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"gemeente-den-haag-2","post_name":"gemeente-den-haag-2","1":"925","ID":"925","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"universiteit-voor-humanistiek-banner-website","post_name":"universiteit-voor-humanistiek-banner-website","1":"1136","ID":"1136","cat_id":"9","cat_name":"illustraties","cat_slug":"illustraties"},{"0":"stadsschouwburg-utrecht-affiche","post_name":"stadsschouwburg-utrecht-affiche","1":"308","ID":"308","cat_id":"1","cat_name":"divers","cat_slug":"divers"},{"0":"mitros-plattegrond","post_name":"mitros-plattegrond","1":"311","ID":"311","cat_id":"1","cat_name":"divers","cat_slug":"divers"},{"0":"trajectbureau-panelen","post_name":"trajectbureau-panelen","1":"317","ID":"317","cat_id":"1","cat_name":"divers","cat_slug":"divers"},{"0":"centraal-museum-ansichtkaart-de-salon","post_name":"centraal-museum-ansichtkaart-de-salon","1":"762","ID":"762","cat_id":"1","cat_name":"divers","cat_slug":"divers"},{"0":"centrada-vlag-en-autobelettering","post_name":"centrada-vlag-en-autobelettering","1":"938","ID":"938","cat_id":"1","cat_name":"divers","cat_slug":"divers"},{"0":"universiteit-voor-humanistiek-affiche","post_name":"universiteit-voor-humanistiek-affiche","1":"941","ID":"941","cat_id":"1","cat_name":"divers","cat_slug":"divers"},{"0":"slachtoffer-in-beeld-traumaverwerking","post_name":"slachtoffer-in-beeld-traumaverwerking","1":"1227","ID":"1227","cat_id":"1","cat_name":"divers","cat_slug":"divers"},{"0":"sovee-young-begeleid-wonen","post_name":"sovee-young-begeleid-wonen","1":"1246","ID":"1246","cat_id":"1","cat_name":"divers","cat_slug":"divers"}]
//CREATE THE PORTFOLIO LINK FOR MAINMENU
//Select the first category
$query_select_categories2 = mysqli_query($con, "
SELECT wp_terms.term_id, wp_terms.name, wp_terms.slug FROM wp_terms, wp_term_taxonomy
WHERE wp_terms.term_id = wp_term_taxonomy.term_taxonomy_id
AND wp_term_taxonomy.taxonomy = 'category'
ORDER BY wp_terms.term_order
LIMIT 1
");
$firstcategory = mysqli_fetch_array($query_select_categories2);
//select the first portfolio item in this category
$query_select_post2 = mysqli_query($con, "
SELECT wp_posts.post_name FROM wp_posts, wp_term_relationships
WHERE wp_posts.ID = wp_term_relationships.object_id
AND wp_posts.post_status = 'publish'
AND wp_term_relationships.term_taxonomy_id = $firstcategory[term_id]
ORDER BY post_date
LIMIT 1
");
$portfolio_link = mysqli_fetch_array($query_select_post2);
$portfolio_url = "/".$firstcategory['slug']."/".$portfolio_link['post_name']."/";
?>