//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']."/";
?>