Support

Account

Home Forums General Issues WP_Query Distinct results Reply To: WP_Query Distinct results

  • Hi @v0rt3x

    You can add some simple logic to test if the option has already been added like so:

    
    <?php 
    
    $added = array();
    $args = array(
    	'post_type' => 'locations',
    	'posts_per_page' => -1,
    	'meta_query' => array(
    	         array(
    			'key' => 'country',
    		)
    	),
    );
    $query = new WP_Query( $args );
    					
    if($query->have_posts()) : 
      echo "<select name='country' class='form-control' id='countryselect'>";
      while($query->have_posts()) : 
    	$query->the_post();
    	
    	// get country
    	$country = get_field('country');
    	
    	
    	// bail early if this country has already been added
    	if( in_array($country, $added) )
    	{
    		continue;
    	}
    	
    	
    	// add country
    	$added[] = $country
    	
    	echo "<option>" . $country . "</option>";
      endwhile;
      echo "</select>";
    endif;
    
     ?>
    

    Hope that helps.

    Thanks
    E