"> echo"$tablesx"; ?> |
"> echo"$UNI_PROGRAM_NAME "; ?> |
"> //echo"$FAC_ID:40 :$PROGRAM_ID ";
if($a=="1"){
$tableSQL1 ="select questionaire.STD_ID, questionaire.QN_WORK_STATUS,student.STD_ID,student.UNI_PROGRAM_ID,student.FAC_ID from questionaire ,student where student.STD_ID=questionaire.STD_ID and student.UNI_PROGRAM_ID='$UNI_PROGRAM_ID' and questionaire.QN_YEAR='$years' and questionaire.QN_WORK_STATUS!='' "; //group by Fild desc limit order by
}else{
$tableSQL1 ="select questionaire.STD_ID, questionaire.QN_WORK_STATUS,student.STD_ID,student.UNI_PROGRAM_ID,student.FAC_ID from questionaire ,student where student.STD_ID=questionaire.STD_ID and student.UNI_PROGRAM_ID='$UNI_PROGRAM_ID' and student.year_budget='$years' and questionaire.QN_WORK_STATUS!='' "; //group by Fild desc limit order by
}
$tableQUERY1= mysql_db_query($dbname, $tableSQL1);
$tableNUM1 = mysql_num_rows($tableQUERY1);
echo"$tableNUM1";
$sum1 = $tableNUM1+$sum1;
?>
|
">รายชื่อ |
">Excel |
"> //echo"$FAC_ID:40 :$PROGRAM_ID ";
if($a=="1"){
$tableSQL3 ="select questionaire.STD_ID, questionaire.QN_WORK_STATUS,student.STD_ID,student.UNI_PROGRAM_ID,student.FAC_ID from questionaire ,student where student.STD_ID=questionaire.STD_ID and student.UNI_PROGRAM_ID='$UNI_PROGRAM_ID' and questionaire.QN_YEAR='$years' and questionaire.QN_WORK_STATUS='' "; //group by Fild desc limit order by
//echo $tableSQL3;
}else{
$tableSQL3 ="select questionaire.STD_ID, questionaire.QN_WORK_STATUS,student.STD_ID,student.UNI_PROGRAM_ID,student.FAC_ID from questionaire ,student where student.STD_ID=questionaire.STD_ID and student.UNI_PROGRAM_ID='$UNI_PROGRAM_ID' and student.year_budget='$years' and questionaire.QN_WORK_STATUS='' "; //group by Fild desc limit order by
//echo $tableSQL3;
}
$tableQUERY3= mysql_db_query($dbname, $tableSQL3);
$tableNUM3 = mysql_num_rows($tableQUERY3);
echo"$tableNUM3";
$sum3 = $tableNUM3+$sum3;
?>
|
">รายชื่อ |
">Excel |
"> $asxxx=$tableNUM1+$tableNUM3;
echo"$asxxx";
?>
|
$tablesx++;
}
?>