[RESOLVED] male/female

[fullyloaded]

hi
i was wondering if anyone can help me with a small pice of coding i have in my website?what im trying to do is get the total number of males signed up to my website and the same for females also.ok here is the code i have to show how many members i have signed up witch would be under (member)and for there gender its under member then (gender)is there anyway this can be done?thanks...

$dbu->query('SELECT COUNT(*) AS rowcount FROM member');
$dbu->move_next();
$ft->assign('MEMBER', $dbu->f('rowcount'));

[bradgrafelman]

I don't know what kind of values you're using, but try a SQL query like:

$query = 'SELECT COUNT(*) AS males FROM member WHERE gender=\'male\'';

Then, once you retrieve the number of males, simply subtract that number from the total number of members and you also have the number of females.

[fullyloaded]

HI bradgrafelman
thank you very much for helpping me it works great!!!
again thank you!!