Custom Taxonomy Query

I have setup two custom taxonomies for a custom post type that I have created. The post type is called beer, and the two taxonomies are country and brewers.

I would like to list them like this.

Read More
 Country
 -->Brewers
 ----->Beers

I can pull the countries using this code.

    $terms_country = get_terms('country');
    foreach ($terms_country as $term_country) {
    echo "<h3 class="country-heading" id="".$term_country->slug."">";
    echo '<a href="/beers/country/' . $term_country->name . '">' . $term_country->name       . '</a>';
    echo "</h3>";

I need to query the country term to list the Brewers that have that taxonomy attached to the post as well.

Related posts

Leave a Reply

1 comment

  1. NOTE: This answer is supposed to be in addition to the answer here

    The function used returns an array of all the items, so the best way to display them is to use a foreach loop. As a usage example

    global $wpdb;
    $result = $wpdb->get_col(....); //copy the line from the aforementioned answer
    
    if($result) {
        echo '<ul>';
        foreach($result as $term) {
            echo '<li>' . $term . '</li>';
        }
        echo '</ul>';
    }
    

    In case you changed the get_col to get_results to query more details about the terms, the foreach loop changes just a little

        foreach($result as $term) {
            echo '<li>' . $term->name . ' with slug ' . $term->slug . '</li>';
        }