ช่วยดูcode ให้หน่อยค่ะ นับจำนวนจากดาต้าเบศ ไม่รู้ผิดตรงไหน

   <?php
include ("config.inc.php");
$sql="select Appendent_id,count(`Appendent_id`) from personnel group by Appendent_id order by Appendent_id";
  $result=mysql_query($sql);
  $rows=mysql_num_rows($result);
  $fields=mysql_num_fields($result);
?>
 </p>
<table width="1000" border="1" bordercolor="#000000">
      <tr>
        <td><div align="center"><strong>ลำดับที่</strong></div></td>
        <td><div align="center"><strong>สังกัด</strong></div></td>
        <td><div align="center"><strong>เพศชาย(คน)</strong></div></td>
        <td><div align="center"><strong>เพศหญิง(คน)</strong></div></td>
        <td><div align="center"><strong>รวม</strong></div></td>
      </tr>
      
<?php
	$sqlAppen="SELECT DISTINCT Appendent_id FROM personnel";
	$resultAppen=mysql_query($sqlAppen);
	$norow=mysql_num_rows($resultAppen);
	$k=0;
	while($rowAppen=mysql_fetch_array($resultAppen))
	{
		$Appen[$k]=$rowAppen["Appendent_id"];
		echo $Appen[$k];
		echo "<br>";
		$k++;
		
	}
	for($i=0;$i<k;$i++)
	{
		$sqlCo="SELECT count(*) as numM FROM personnel WHERE Appendent_id='$Appen[$i]' AND Sex='ชาย'";
		$sqlCo="SELECT count(*) as numM FROM personnel WHERE  Sex='ชาย'";
		$result2=mysql_query($sqlCo);
		$rowCo=mysql_fetch_array($result2);
		$countM=$rowCo["numM"];
		echo $countM;
 	}
	
 $i=1;
$sum=0;
  while($row=mysql_fetch_array($result))
  {
  	$sum+=$row[1];
 ?>
 <tr>
	<td><div align="center"><?php echo $i;?></div></td>
	<td><div align="center"><?php echo $row[0];?></div></td>
 <?php
 	
	//echo $rowCo['Pers_FnameT'];
	//$noRow=mysql_num_rows($result2);
    
 ?>
    <td><div align="center"><?php echo $countM;?></div></td>
    <td><div align="center"> </div></td>
    <td><div align="center"><?php echo $row[1];?></div></td>
  </tr>
 <?php
 	$i++;
   }	
?>
 <tr>
	<td><div align="center">รวม</div></td>
	<td><div align="center"> </div></td>
    <td><div align="center"> </div></td>
    <td><div align="center"> </div></td>
    <td><div align="center"><?php echo $sum;?></div></td>
  </tr>
    </table>