counting specific variables

[deltaforce229]

hi i was wondering how to count specific variables in an sql database and have it echo the count in a php script.

below is what i have so far.

  $query = "SELECT * FROM ibf_members WHERE mgroup";

$result = mysql_query($query) or die("Query Ruter failed");

         while ($row = mysql_fetch_array($result));
 

i dont know what to do from there

[devinemke]

$result = mysql_query('SELECT COUNT(*) FROM ibf_members') or exit(mysql_error());
echo mysql_result($result, 0);

[deltaforce229]

mgroup variables are 1-10 i want to add up all the 6's and display it

[kburger]

MySQL aggregate functions

[deltaforce229]

thank you