Wordpress: Display posts by custom select query

Question

I need Wp_query with two custom fields, one custom field for orderby and another: (if this key exists in the post so show the post else dont add this post to query.) I tried like this but doesnt work... Any help?

$args = array(
'post_type' => 'post',
'meta_query' => array(
    array(
        'key' => 'Apple',
    ),
    array(
        'key' => 'Price',
        'type' => 'numeric',
    )
),
'orderby' => 'meta_value_num',
'paged' => get_query_var('paged'),
'order'=> 'DESC',
    );
$the_query = new WP_Query( $args );

As you can see I want to show posts which has custom field "Apple", and want to order by the custom field "Price", From lowest to highest price.

Bainternet · Accepted Answer · 2012-01-10 13:51:28Z

2

try this:

$args = array(
'post_type' => 'post',
'meta_query' => array(
    array(
        'key' => 'Apple',
        'value' => '',
        'compare' => 'NOT LIKE'
    )
),
'meta_key' => 'Price',
'orderby' => 'meta_value_num',
'paged' => get_query_var('paged'),
'order'=> 'DESC',
    );
$the_query = new WP_Query( $args );

answered Jan 10, 2012 at 13:51

Bainternet

67.8k8 gold badges132 silver badges188 bronze badges

Thank you so much!!! it works I was trying with select query, but this is much easier.

andys
– andys

2012-01-10 16:33:36 +00:00
Commented Jan 10, 2012 at 16:33

Add a comment |

Stack Exchange Network

Wordpress: Display posts by custom select query

1 Answer 1

Your Answer

Hot Network Questions

Wordpress: Display posts by custom select query

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions