ขอความกรุณาช่วยหน่อยคะ หนูต้องการ นับจำนวนข้อมูลที่อยู่ใน database แบบแยกตามประเภทคะ

$sql = mysql_query("SELECT DISTINCT subject_ID FROM select_course");
while($F1=mysql_fetch_array($sql))
{
$sql2 = mysql_query("SELECT subject_ID As coun from  select_course where subject_ID = '$F1[subject_ID]'");
echo "<br>";
echo $F1[subject_ID];
echo "<br>";
echo mysql_num_rows($sql2);
}

$sql="SELECT subject_ID,  COUNT(subject_ID) as count_subject  FROM select_course group by subject_ID";
$rs = mysql_query( $sql) or die ($sql . "<br>" . msyql_error() );
while($F1=mysql_fetch_assoc($sql)){
     echo $F1['subject_ID'], "&nbsp" , $F1['count_subject'], "<br>";
}