วนลูปแนวตั้ง ข้อมูลแสดงผลไม่ครบ รบกวนผู้รู้ช่วยด้วยค่ะ

<table width="226" border="1">
  <?	 	 
		$sqlC 	= "select * from category order by c_id asc";
      	$queryC	= mysql_query($sqlC) or die("error=$sqlC");
		$numC 	= mysql_num_rows($queryC);
		for($i=1;$i<=$numC;$i++)
		{
        	$rowC   = mysql_fetch_array($queryC); 
?>
  <tr>
    <td width="216" bgcolor="#FFFF99"><div align="center"> ประเภท
        <?=$rowC['c_id']?>
      </div></td>
  </tr>
  <?	 
			$C_id=$rowC['c_id'];
			$sqlP 	= "select * from product  where c_id='$C_id' order by p_id asc";
			$queryP	= mysql_query($sqlP) or die("error=$sqlP");
			$numP 	= mysql_num_rows($queryP);
			for($i=1;$i<=$numP;$i++)
			{
				$rowP   = mysql_fetch_array($queryP); 
			?>
  <tr>
    <td><?=$rowP['p_name']?></td>
  </tr>
  <?
			}
	     }
	?>
</table>

<table width="226" border="1">
  <?	 	 
		$sqlC 	= "select * from category order by c_id asc";
      	$queryC	= mysql_query($sqlC) or die("error=$sqlC");
		while($rowC= mysql_fetch_array($queryC)){
 
?>
  <tr>
    <td width="216" bgcolor="#FFFF99"><div align="center"> ประเภท
        <?=$rowC['c_id']?>
      </div></td>
  </tr>
  <?	 
			$C_id=$rowC['c_id'];
			$sqlP 	= "select * from product  where c_id='$C_id' order by p_id asc";
			$queryP	= mysql_query($sqlP) or die("error=$sqlP");
			while($rowP = mysql_fetch_array($queryP)){
			?>
  <tr>
    <td><?=$rowP['p_name']?></td>
  </tr>
  <?
			}
	     }
	?>
</table>