WordPress :: WP Questions :: Our Experts Are Ready To Answer Your Questions

This is an old version of this answer!

You could retrieve first the post_ids with get_posts, then query those post ids. Instead of:

query_posts('paged='.$paged.'&cat='.$thiscategory.'&meta_key='.$meta_key .'&orderby='.$orderby .'&order='.$order .'&meta_value='.$brandName.'');

...we could use something like:



$post_ids = array();

$meta_key = 'product_brand'; //retrieve by brand

$unordered_posts = get_posts('paged='.$paged.'&cat='.$thiscategory.'&meta_key='.$meta_key);

foreach( $unordered_posts as $unordered_post ){

$post_ids[]= $unordered_post->ID;

};

query_posts( array( 'post__in' => $post_ids , 'order' => 'meta_value_num' , 'orderby' => $orderby , 'meta_key' => 'Retail_Price'  ) );

Xavier Faraudo | 07/28/10 at 9:12pm