รบกวนขอตัวอย่าง code การแสดงตารางผลการเรียน คือทำระบบลงทะเบียน แต่ติดที่การแสดงผลการเรียนรวมทุกเทอม อยากให้แบ่งเป็นผลการเรียนที่ลงในแต่ละภาคเรียนต่อปีการศึกษา

<?php
 session_start(); 

$name_my=$_GET[name_my];
$name_last=$_GET[name_last];
$id_regis_online=$_GET[id_regis_online];
$student_id=$_GET[student_id];
$th_id=$_REQUEST[th_id];
$check=$_REQUEST[check];
$id_regis_online=$_REQUEST[id_regis_online];
$student_id=$_REQUEST[student_id];
 $bb=$_REQUEST[bb];


<TABLE width=525 height=250>
							<TR>
							  <TD align=center valign="top"><br>
							  <? 
							  include 'connect.php';
							
							  	/*$sql="select max(year_stu) as max_year_stu  from sec";
								$res=mysql_db_query($dbname,$sql);
								$row=mysql_fetch_array($res);
									$max_year_stu=$row[max_year_stu];
									$total_year=$max_year_stu;
									$n=$total_year;*/
								do { 	
																	  
							 $sql1="select * from sec where student_id=$_GET[student_id]";
							  $query1=mysql_db_query($dbname,$sql1);
							  while ($res1=mysql_fetch_array($query1)){
							 print $year_stu=$res1[year_stu];
							 
								  

   //$term;
?>

 

<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#81B9D4" style='border:1px solid #0099CC'>
                             <tr>
                               <td height="25" colspan="6" bgcolor="#FFCC66"> รหัสนักเรียน&nbsp;<?=$student_id?></td>
                    </tr>
                             <tr>
							 
                               <td height="25" align="center" bgcolor="#C9E9F9">รหัสวิชา</td>
                               <td height="25" align="center" bgcolor="#C9E9F9">ชื่อวิชา</td>
                               <td height="25" bgcolor="#C9E9F9">ภาคเรียน&nbsp;</td>
                               <td height="25"  align="center" bgcolor="#C9E9F9">ปีการศึกษา</td>
                               <td height="25" align="center" bgcolor="#C9E9F9">หน่วยกิต</td>
                               <td height="25" align="center" bgcolor="#C9E9F9">เกรด</td>
                             </tr>
                             <tr><? $stu=$student_id?>
							
								    <?
								
								 include "connect.php";
								  mysql_query("SET NAMES TIS620");
								  
								  //and t_year='1' and year_stu='$year_stu'
								  $sql="select * from sec  where student_id='$stu'  order by  id_sec ";
								  $res=mysql_db_query($dbname,$sql);
							
								  while($r=mysql_fetch_array($res))
								  {
								 	$id_sec=$r[id_sec]; 
  $student_id=$r[student_id];
   $subject_id=$r[subject_id];
   $name_subject=$r[name_subject ];
   $name_stu=$r[name_stu];
  $sec_no=$r[sec_no];
  $time_begin =$r[time_begin];
  $time_end=$r[time_end];
  $day_sec=$r[day_sec];
  $room_id =$r[room_id];
  $grade=$r[grade];
  $wut=$r[wut];
  $t_year=$r[t_year];
  $year_stu=$r[year_stu]; 
  $unit =$r[unit]; 	
  ?>
                    
								
                                    <td width="13%" height="25" align="center" bgcolor="#E0F5F6"><?=$subject_id?></td>
                                    <td width="42%" height="25" bgcolor="#E0F5F6"><font color="#FF6600"><?=$name_subject?></font></td>
                                    <td width="14%" height="25" align="center" bgcolor="#E0F5F6"><?=$t_year?>
                                    &nbsp;</td>
                                    <td width="13%" height="25" align="center" bgcolor="#E0F5F6"><?=$year_stu?>                                      &nbsp;</td>
                                    <td width="10%" height="25" align="center" bgcolor="#E0F5F6">&nbsp;<?=$unit?></td>
                                    <td width="8%" height="25" align="center" bgcolor="#E0F5F6">&nbsp;<?=$grade?><? $gpag=$grade;?></td>
                    </tr>  
								  <?
								 } 
?>						
								  
                                </table>
						        <p>
						
								<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="9%" height="20" bgcolor="#99FFFF">&nbsp;</td>
    <td width="20%" bgcolor="#99FFFF">เกรดเฉลี่ย</td>
    <td width="71%" height="20" bgcolor="#99FFFF">&nbsp;
						
						<?
								  include "connect.php";
								  mysql_query("SET NAMES TIS620");
 //and t_year='1' and year_sec='$year_stu'
 $result1= mysql_query("SELECT sum(total) FROM sec  where student_id='$student_id' order by t_year and  year_sec asc"); 
		 		
	if ($result1)
	{ 
	$query_data1=mysql_fetch_array($result1);
	$total_s=$query_data1["sum(total)"];

	}
	
	 ?>
<?
include "connect.php";
mysql_query("SET NAMES TIS620");
 //and year_sec='$year_stu' and t_year='1'  
$result = mysql_query("SELECT sum(unit) FROM sec where student_id='$student_id' order by t_year and  year_sec asc"); 
	if ($result)
	{ 
	$query_data=mysql_fetch_array($result);
	$total_unit=$query_data["sum(unit)"];
	//echo $total; 
	}
	 ?>
	<?
	
	  $total_u=$total_unit*4;
	  print $aaa=($total_s*4)/$total_u;
	 
		
	?>	</td>
  </tr>
  <tr>
    <td height="20" bgcolor="#FF9999">&nbsp;</td>
    <td height="20" bgcolor="#FF9999">เกรดเฉลี่ยสะสม</td>
    <td height="20" bgcolor="#FF9999">&nbsp;<?=$aaa?></td>
  </tr>
</table> 
<?
$term++; 
} 
}
while ($term < 4); 

		

?>