Someone please help - Multiple Selection Profile Fields

[jarekn]

I posted this in PHP thread but I think it should go here...sorry

I've gone over the the post in this thread:
http://www.vbulletin.com/forum/showthread.php?t=108785

All is fine however I am writing a custom report that counts users by age, location and what not... eg:

$totalmales = mysql_result(mysql_query("SELECT count(*) FROM user, userfield where user.userid=userfield.userid and userfield.field5='Male'"),0);


Now I got to the part where I need to count them by selected specific fields in their profile...

Eg users that have first option enabled, users that have second option enabled... Any idea how to go about it? Sample please?

Someone please :)

Please...