You can do what you want by using a join filter. Code the query_posts() to select the price and sort on it. Then use code like the following (UNTESTED!) before the query to set an additional join condition on the brand.
$brand = 'thebrandtoshow'; // Put the selected brand here
function mam_posts_join ($join) {
global $mam_global_join;
if ($mam_global_join) $join .= $mam_global_join;
return $join;
}
add_filter('posts_join','mam_posts_join');
$mam_global_join = " JOIN $wpdb->postmeta as brand ON ($wpdb->posts.ID = brand.post_id AND brand.meta_key = 'brand' AND brand.meta_value ='$brand'";
Thanks vtxyzzy, could you possibly tailor this to my case below? The else case of the if/then is where I need to restrict the output to the current value of $brandName, but need to sort by the value of meta_key ‘Retail_Price’. Any tips? Thanks!
<?php
$brandName= $_GET['brandName'];
$order= $_GET['order'];
if (isset($brandName)) {
} else {
$brandName = "ALL";
}
if (isset($order)) {
} else {
$order = "DESC";
}
if ($brandName=="ALL") { // NO BRAND SET - WE WANT TO JUST SORT ACCORDING TO THE $ORDER VAR
//echo ('simple case');
$meta_key= "Retail_Price";
$orderby= "meta_value_num";
query_posts('paged='.$paged.'&cat='.$thiscategory.'&meta_key='.$meta_key.'&orderby='.$orderby.'&order='.$order.'');
} else { // A BRAND IS SET, SO WE NEED TO DO THE FULL SHEBANG- RESTRICT TO BRAND, SORT BY $ORDER
$meta_key= "product_brand";
$orderby= "meta_value";
query_posts('paged='.$paged.'&cat='.$thiscategory.'&meta_key='.$meta_key .'&orderby='.$orderby .'&order='.$order .'&meta_value='.$brandName.'');
}
?>
You need to get it working to sort by price first. If that doesn’t work, a different approach will be necessary.
