while ($row = mysql_fetch_array($result)) { $classes = $row['groupname']; if($classes=='Sales')$i++; } echo $i;