MyBB Community Forums

Hi,

I admin an australian rules football forum. We have "my team" set as a mandatory custom profile field that shows in the postbit. We're just getting started, and I was wondering if there is a way for me to query how many users have chosen each of the 18 teams in the competition?

If it matters, this is ideally for where we should market and what teams lack a member base.

Forum is at http://ourfooty.com.au/forum if you want a look see

Cheers

Go into phpmyadmin and run this query:

SELECT * FROM mybb_userfields WHERE fidX='value'

Replace fidX with the fid number, e.g. fid4

Replace value with the value of the field.

phpmyadmin will say how many rows were selected, and there's your number.

Thanks, worked like a charm