How to rank custom post type from score points

You can run a WP_Query to get all the posts from post_type casinos and sort them with the custom field value casino_rank_score. Then you can further process it to display ranks.

$args = array(
    'post_type' => 'casinos',
    'meta_key' => 'casino_rank_score',
    'orderby' => 'meta_value_num',
    'posts_per_page' => 350,
    'ignore_sticky_posts' => 1,
);

$my_query = new WP_Query( $args );

If you only need to display one post only like RANKED #2 of 350 CASINOS then you can limit your results with 'posts_per_page' => 1, and offset by 1 'offset' => 1,
This wway you will get 2nd ranked casino.

EDIT

To get rank you will need to run a custom query. And this is how you can get rank of current post in your custom query. It is optimized because we are only returning ID, no post data is requested so it’s pretty fast. But to optimize it even further, you can cache this query with Transients_API for couple of hours or days.

$args = array(
    'post_type' => 'casinos',
    'meta_key' => 'casino_rank_score',
    'orderby' => 'meta_value_num',
    'posts_per_page' => -1,
    'ignore_sticky_posts' => 1,
    'fields' => 'ids',
);

$my_query = new WP_Query( $args );

global $post;

$total_casinos = $my_query->post_count;
$casinos_rank = array_search( $post->ID, $my_query->posts ) + 1;

echo "RANKED #" . $casinos_rank . " of " . $total_casinos . " CASINOS";

This is tested and working

Related Posts: