Reply To: Querying the database for repeater sub field values – shows duplicate results

• shaunklink

• July 28, 2016 at 3:06 am

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
));