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

• shaunklink

• July 28, 2016 at 3:01 am

I forgot to post my query:

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