BuddyPress.org

That’s a serialize()’d array, which is a storable representation of a value. It looks like an array. You need to un-serialize it. You don’t need to use a direct SQL query for that, either, and if you were, you need to use $wpdb->prepare() for security. But I’d suggest doing it like so:


$your_var = maybe_unserialize( xprofile_get_field_data( $fieldID, $id ) );
echo var_dump( maybe_unserialize( $your_var ) );