คำนวนฐานข้อมูล ตามที่เรากรอกไป ใช้ and ไม่ได้ค่ะ เลื่อนดู code + คำถามด้านล่างค่ะ

Quote:

<table width="98%" border="0">
<tr>
<td width="18%" height="194" background="pic/logo.jpg">&nbsp;</td>
<td width="82%"><img src="pic/bar3.jpg" width="816" height="48"></td>
</tr>
</table>
<p>&nbsp;</p>
<hr>
<form name="form1" method="post" action="check_db.php" enctype="multipart/form-data">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<?

include("config.inc.php");
mysql_connect($hostname, $user, $password) or die("ติดต่อฐานข้อมูลไม่ได้");
mysql_select_db($dbname) or die("เลือกฐานข้อมูลไม่ได้");
mysql_query("SET NAMES 'tis620'");
$tb_year =$_POST["tb_year"];
$tb_year2 =$_POST["tb_year2"];
$tb_year3 =$_POST["tb_year3"];
$tb_year4 =$_POST["tb_year4"];
$tb_year5 =$_POST["tb_year5"];
$tb_year6 =$_POST["tb_year6"];
$tb_year6 =$_POST["tb_year7"];
//////////////////////////////////////////////// 1 เทอม //////////////////////////////////////////////////////////
$max = mysql_query("select SUM(tb_grade*tb_noykid)/SUM(tb_noykid) from tb_g where tb_year='$tb_year' ");
$max2 = mysql_query("select SUM(tb_grade*tb_noykid)/SUM(tb_noykid) from tb_g where tb_year='$tb_year' ");
$max3 = mysql_query("select SUM(tb_noykid) from tb_g where tb_year='$tb_year' ");
$max4 = mysql_query("select SUM(tb_noykid) from tb_g where tb_year='$tb_year' ");
//////////////////////////////////////////////// 2 เทอม //////////////////////////////////////////////////////////
$maxAA = mysql_query("select SUM(tb_grade*tb_noykid)/SUM(tb_noykid) from tb_g where tb_year='$tb_year' or tb_year='$tb_year2' ");
$maxAA2 = mysql_query("select SUM(tb_grade*tb_noykid)/SUM(tb_noykid) from tb_g where tb_year='$tb_year' or tb_year='$tb_year2' ");
$maxAA3 = mysql_query("select SUM(tb_noykid) from tb_g where tb_year='$tb_year' or tb_year='$tb_year2' ");
$maxAA4 = mysql_query("select SUM(tb_noykid) from tb_g where tb_year='$tb_year' or tb_year='$tb_year2' ");
//////////////////////////////////////////////// end //////////////////////////////////////////////////////////
$total_max = mysql_result($max,0);
$total_max2 = mysql_result($max2,0);
$total_max3 = mysql_result($max3,0);
$total_max4 = mysql_result($max4,0);
$full=number_format($total_max, 2);
$full2=number_format($total_max2, 2);
$full3=number_format($total_max3, 0);
$full4=number_format($total_max4, 0);
//// คำนวณเทอม 2
$total_maxAA = mysql_result($maxAA,0);
$total_maxAA2 = mysql_result($maxAA2,0);
$total_maxAA3 = mysql_result($maxAA3,0);
$total_maxAA4 = mysql_result($maxAA4,0);
$fullAA=number_format($total_maxAA, 2);
$fullAA2=number_format($total_maxAA2, 2);
$fullAA3=number_format($total_maxAA3, 0);
$fullAA4=number_format($total_maxAA4, 0);

echo "<CENTER> ปีการศึกษา : $tb_year</CENTER>";
echo "<CENTER><p>เกรดเฉลี่ย : $full เกรดเฉลี่ยสะสม : $full2</CENTER>";
echo "<CENTER><p>จำนวนหน่อยกิตแต่ละภาคเรียน : $full3 หน่วยกิตสะสม : $full4</CENTER><hr>";

echo "<CENTER> ปีการศึกษา : $tb_year2</CENTER>";
echo "<CENTER><p>เกรดเฉลี่ย : $fullAA เกรดเฉลี่ยสะสม : $fullAA2</CENTER>";
echo "<CENTER><p>จำนวนหน่อยกิตแต่ละภาคเรียน : $fullAA3 หน่วยกิตสะสม : $fullAA4</CENTER><hr>";
mysql_close();
?>
<input type="hidden" name="tb_year" value="<? echo $tb_year; ?>">
<input type="hidden" name="full" value="<? echo $full; ?>">
<input type="hidden" name="full2" value="<? echo $full2; ?>">
<input type="hidden" name="full3" value="<? echo $full3; ?>">
<input type="hidden" name="full4" value="<? echo $full4; ?>">
<CENTER><input name="btnSubmit" type="submit" value="Save & Update"></CENTER>