Topic: filter Members with specific Fields (query string) · BuddyPress.org

Skip to:: Content; Pages; Categories; Search; Top; Bottom

filter Members with specific Fields (query string)

emidio007
Participant

@emidio007

9 years, 10 months ago

Hello all together,
I have a query string e.g. “?field_9=Man&field_10=Woman&field_2=25&field_2_to=35&field_69_min=165&field_69_max=175” and would like to list all the Members who have chosen similar fields. like a matched Profiles.

How can i list specific members? or should I split (explode) the query string in an array and read the whole thing with PHP loop?

Maybe someone could help me or give a similar approach.

Thanks in advance

Viewing 1 replies (of 1 total)

emidio007
Participant

@emidio007

9 years, 10 months ago

I think I’ll solve it as provisional. i’ll split getString into an array

SELECT *
FROM wp_bp_xprofile_data
WHERE field_id =9
AND value LIKE ‘Woman’
AND field_id =10
AND value LIKE ‘Man’
OR field_id =26
AND value LIKE ‘Rom’

Viewing 1 replies (of 1 total)

The topic ‘filter Members with specific Fields (query string)’ is closed to new replies.