BuddyPress.org

I’d approach this a different way -

something like:
`
$match_ids = $wpdb->get_var( “SELECT user_id FROM wp_bp_xprofile_data WHERE field_id = [whatever the field_id is for State] AND value = [whatever value you want to find] “);
`

$match_ids will be a simple array.
So loop thru the array and create a comma separated string out of the ids.
Then pass the string to bp_has_members() using ‘include’

something like
`
//$get_these_members is the id string you created
$get_these_members = ‘include=’ . substr($get_these_members, 0, -1); //trim the last comma

if ( bp_has_members( $get_these_members ) )
`

That way you could search for any value on any profile field.
Your approach might work, but… yikes.

http://codex.buddypress.org/developer-docs/custom-buddypress-loops/the-members-loop/