[SOLVED] different types of members count

[nomanoma]

hi:

i have a website that has 3 types or memberships. i can get my site to show all members count by this:

$count= mysql_query("select * from members WHERE verified=1");

    $rowcount = @mysql_num_rows($count);

 

what i want is to show the member count of each type separately.

 

i'm new to php, so please can anyone help?

 

noma

[Maq]

You have to use COUNT() and GROUP BY to accomplish this.

[fenway]

As in:

 

select memberType, COUNT(*) as cnt from members WHERE verified=1 GROUP BY memberType