Sorting on multiple custom fields

  • Hi,

    I’m creating a site for a football team, and am trying to create a league table where all the values are stored into custom fields.

    When I’m displaying this on, I cannot find a way of sorting by 2 custom fields together (ie, if points are equal, sort by goal difference). I have followed though this article (https://codex.www.ads-software.com/Displaying_Posts_Using_a_Custom_Select_Query) but I can’t work out how to modify it to query/sort both.

    Any suggestion’s welcome – my custom field name’s are ‘pts’ and ‘goal-diff’, and are stored in a custom post type ‘league-table’.

    Thanks – Paul.

Viewing 1 replies (of 1 total)

  • I do not have a way to test this, but I think this query is what you want:

    $querystr = "
    SELECT $wpdb->posts.*,pt.meta_value as pts, goal.meta_value as goal_diff
    FROM $wpdb->posts, $wpdb->postmeta pt, $wpdb->postmeta goal
    WHERE $wpdb->posts.ID = pt.post_id
    AND pt.meta_key = 'pts'
    AND $wpdb->posts.ID = goal.post_id
    AMD goal.meta_key = 'goal-diff'
    AND $wpdb->posts.post_status = 'publish'
    AND $wpdb->posts.post_type = 'league-table'
    AND $wpdb->posts.post_date < NOW()
    ORDER BY pts + 0 ASC, goal_diff + 0 ASC, UPPER($wpdb->posts.post_title) ASC
 ";
Viewing 1 replies (of 1 total)
  • The topic ‘Sorting on multiple custom fields’ is closed to new replies.