Add two functions to function.php:
function home_modify_query( $query ) {
if ( is_home() ) {
$query->set( 'meta_key', 'zip_code' );
$query->set( 'orderby', 'meta_value' );
$query->set( 'order', 'ASC' );
}
return $query;
}
add_filter('pre_get_posts','home_modify_query');
function sort_posts_orderby( $orderby ) {
if ( is_home() ) {
$orderby = 'wp_postmeta.meta_value ASC, wp_posts.post_date DESC';
return $orderby;
}
}
add_filter( 'posts_orderby', 'sort_posts_orderby' );
Thank you. The function doesn’t sort out the date. I have this function currenlty but it is slow:
add_filter('pre_get_posts', 'sort_my_archive');
function sort_my_archive($q) {
if ($q->is_tax || $q->is_archive) {
add_filter( 'posts_orderby', 'orderby_bad_car' );
}
return $q;
}
function orderby_bad_car( $order ) {
$order = "(SELECT meta_value FROM wp_postmeta WHERE meta_key = 'wpcf-bad-car' AND post_id = wp_posts.ID) ASC, wp_posts.post_date desc";
return $order;
}
[Moderator Note: Please post code & markup between backticks or use the code button. Your posted code may now have been permanently damaged by the forum’s parser.]
