It is not the most elegant solution, but you could sort the results on your search page: At the top of your page, make the wp_query variable available global $wp_query; Later in you code, if there are some results : if ( have_posts() ) { //your desired order $order = array(45, 78, 94); // a … Read more
WP Query. Ordering posts by another post types meta
If I understand correctly what you’re trying to accomplish, you’ll probably want “post meta” (post meta data) to be updated in relation to the 3rd party program, then adjust the post query to look for it before outputting posts. This objective can be accomplished in different ways, the simplest ones not necessarily requiring input from … Read more
I can see in your code you did mistakes with meta key arguments. You must use underscore instead of hyphen sign. Here is corrected code: $args = array( ‘number’ => 5 , ‘meta_key’ => ‘post_count’, ‘meta_value’ => 10, ‘meta_compare’ => ‘>’, ‘orderby’ => ‘rand’ ); $user_query = new WP_User_Query( $args ); if ( ! empty( … Read more
I tried this code and it should work for you In your function.php to make random order available in WP_User_Query function my_random_user_query( $class ) { if( ‘rand’ == $class->query_vars[‘orderby’] ) $class->query_orderby = str_replace( ‘user_login’, ‘RAND()’, $class->query_orderby ); return $class; } add_action( ‘pre_user_query’, ‘my_random_user_query’ ); Source And a query like this // Get all users id … Read more
Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
My archives page won’t sort posts by month
There shouldn’t be a foreach loop inside the while. The while loops over posts, so you don’t need another foreach. The while loop in this context is what WordPress calls “The Loop”. See the section of documentation for The Loop on secondary queries here. So your loop should look like this: <?php while ( $posts->have_posts() … Read more
You need to identify the tables for each of the columns that have the same name. You should also be using an IN statement and not = for the department. I can’t test this since I don’t have your DB but you can try this: $sql = $wpdb->get_results(“SELECT * FROM ” . $wpdb->prefix . “dir_personnel … Read more
I continued to research my issue and ended up finding the solution here: I need query_posts() to order results first by a meta value and then by post ID Basically, it seems the WordPress orderby is screwed. When I examined the SQL it was producing the orderby looked like this: ORDER BY wppc_postmeta.meta_value+0 DESC Which … Read more