4

With use of the Advanced Custom Fields plugin I created a select dropdown which contains 6 membership types. All of my 'listings' using this custom field are assigned one of the 6.

ACF field: Membership Type

I'd like to display all 'listings' by:

Ultimate Plus
Ultimate
Professional
Commercial
Business
Free

In this particular order, so those paying for the highest level membership have their 'listing' appear at the top of the page.

I expected it to be similar to this which I just found but unsure exactly:

// args
$args = array(
'post_type'  => 'directory_listings',
'meta_key'   => 'free',
'orderby'    => 'meta_value_num',
'order'      => 'ASC',
'meta_query' => array(
    array(
        'key'     => '#',
        'value'   => array( #, # ),
        'compare' => 'IN',
    ),
),
);

// query
$wp_query = new WP_Query( $args );

?>

<?php if (have_posts()) : ?>

    <?php
    while( $wp_query->have_posts() ) {
        the_post();
        ldl_get_template_part('listing', 'compact');
        ldl_get_featured_posts();
    }
    ?>

<?php else : ?>

<?php endif; ?>
Nabil Kadimi
  • 10,078
  • 2
  • 51
  • 58
wharfdale
  • 1,148
  • 6
  • 23
  • 53
  • 2
    Following this one. I can see a lot of future use. I added the ACF tag so it will bump up your visibility. – Aibrean Nov 20 '14 at 15:58

1 Answers1

5

You are almost there

If you change the choices in the Advanced Custom Fields to 

1 : Free
2 : Business
3 : Commercial
4 : Professional
5 : Ultimate
6 : Ultimate Plus

And then the default to 1

By doing this you are setting the values to the number and the default is the Free value. In the admin screen you will be presented with the text value.

Then to do your query try this for the query

$wp_query = get_posts(array(
  'numberposts' => -1,
  'post_type' => 'directory_listings',
  'meta_key' => 'membership_type',
  'orderby' => 'meta_value',
));

It will get all of the posts that have a value set and order it by the membership type descending which is what you want.

I have tried this on my local setup to confirm this.

Andrew Fielden
  • 153
  • 2
  • 7
  • In addition to this, do you know how I may be able to get all the appropriate listings, in order as previously requested but only from the category you're currently in? I am getting the results of Ultimate Plus etc levels from every category whilst in any category right now. – wharfdale Dec 02 '14 at 13:36
  • If you only want one of the categories then add 'meta_value' => 2, // for business etc.. – Andrew Fielden Dec 04 '14 at 20:28
  • good example, BUT why 1. `'numberposts' => -1` is added here, I don't see OP wants to unlimit query 2. this will spoil all your already published posts – vladkras Aug 16 '15 at 16:24
  • I need exactly what OP asks: sort the posts in the order these values are – vladkras Aug 16 '15 at 16:31
  • @AndrewFielden Could you help me with [this](http://stackoverflow.com/questions/42371746/is-it-possible-to-query-posts-in-the-same-order-as-assigned) ? I am in a same situation with a little more complex work but can't seem to figure it out. – Antonios Tsimourtos Feb 28 '17 at 13:06