| เลือกปีการศึกษา
mysql_query("set NAMES tis620");
if(isset($_GET['year'])) //ถ้าเป็นการเลือกปีครั้งใหม่
{
$txtyear = $_GET['year'];
if($txtyear =='0000') //แสดงทั้งหมด
{
$sql = ("SELECT App_age from applicants");
}
else
{
$sql = ("SELECT App_age from applicants where App_year = '$txtyear' ");
}
}
else
{
$sql = ("SELECT App_age from applicants");
}
$result = mysql_query($sql);
$i = 0;
$num1 = 0;
$num2 = 0;
$num3 = 0;
$num4 = 0;
$num5 = 0;
while ($fetcharr = mysql_fetch_array($result))
{
$age = $fetcharr[App_age];
if ($age <= 16) {$num1++;}
else if ($age == 17){$num2++;}
else if ($age == 18){$num3++;}
else if ($age ==19){$num4++;}
else if ($age >= 20){ $num5++;}
$i++;
}
?> |