Php Record Counter

do you have any other table aside the one with the 100 records? if you dont, i think you need one more for the pending member.
also you can post the application schematic, so we can have a better understand of how the application is suppose to work

//To get male and female
$sql=SELECT count(*) as total, sex  FROM myTable GROUP BY sex

//to get registered and pending
$sql=SELECT count(*) as total, status  FROM myTable GROUP BY status

//to count all members after running mysql_query
mysql_num_rows($result);

dhtml, it is possible but the point of at least my code is not to provide answers based on his table structure but for the purpose of understanding where he needs to go.

The poster should be able to infer from our respective code snippets what he needs to do:
1) Get the number of rows
2) Filter the results, if applicable
3) group or order the results, if applicable.