Profile search form that shows number of members next to checkboxes

Hi Agnes,

BP serializes the checkbox field values for a given member and stores them all together in the same database field.

So you can’t write a single SQL query to get the member count for each checkbox value, but you have to extract all the checkbox values from the database, and count them in PHP.

A more complex approach could be to keep those counters in a WP option, and update them whenever a member’s profile is added, deleted or updated.

Hope this helps!