Support

Account

Home Forums ACF PRO Querying the database for repeater sub field values – shows duplicate results Reply To: Querying the database for repeater sub field values – shows duplicate results

  • I might have fixed it myself, hopefully someone can tell me if this is wise or not, but I added to the query from the tutorial:

    GROUP BY meta_key

    the the full query is now:

    $rows = $wpdb->get_results($wpdb->prepare( 
        "
        SELECT * 
        FROM {$wpdb->prefix}postmeta
        WHERE meta_key LIKE %s
            AND meta_value = %s
        GROUP BY meta_key",
        'friend_partner_entry_%_show_logo_on_home', // meta_name: $ParentName_$RowNumber_$ChildName
        '1' // meta_value: 'type_3' for example
    ));