Support

Account

Home Forums General Issues football leadscore

Solving

football leadscore

  • Hi, good evening.
    I am currently building a football related website.
    I have a profile page for each player, where I put all its data (such as number of appearance, number of goals, etc.) using the Custom Fields.
    I have another page of Top Scorring Leadboard, when the data (player name + and number of goals), I pull from each player’s profile.
    The problem is that I need to sort from top to bottom by a number of goals on each page where and it’s a bit complicated.

    is it possible to do it with this plugin? and if so, than how to?

    I’d be happy to get some help.
    Thanks

  • Hi Orimomo

    A custom query using the get_posts function is your best option, http://codex.wordpress.org/Template_Tags/get_posts

    The custom query could be build using the following

    <?php
    $args = array(
      'posts_per_page'   => -1,
      'offset'           => 0,
      'category'         => '',
      'orderby'          => 'meta_value_num',
      'order'            => 'DESC',
      'include'          => '',	
      'exclude'          => '',
      'meta_key'         => 'player_goals',
      'meta_value'       => '',
      'post_type'        => 'post',
      'post_mime_type'   => '',
      'post_parent'      => '',
      'post_status'      => 'publish',
      'suppress_filters' => true 
    ); 
    
    $posts_array = get_posts( $args );
    ?>

    You could then use a loop to iterate over all of the returned post items and use standard functions to get the data

    foreach ( $posts_array as $post ) : setup_postdata( $post ); ?>
      <?php 
        $name = get_field('player_name);
        $goals = get_field('player_goals);
      ?>
    <?php endforeach;

    If you have created a custom post type for players change the post_type from post to whatever you have called your custom post type

  • thanks for the answer.

    but one questions please:

    where do i put the first code you show, and where i put the other one?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.