File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>��������´���ҧ���¹ </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<STYLE>UNKNOWN {
	PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px
}
BODY {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
P {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
DIV {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
SPAN {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
TH {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
TD {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
A {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
DD {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
DL {
	FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif"; TEXT-DECORATION: none
}
A:link {
	COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
	COLOR: #000000; TEXT-DECORATION: none
}
A:active {
	COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
	COLOR: #FF3300; TEXT-DECORATION: underline
}
</STYLE>

</HEAD>

</td>
  </tr>
  <tr> 
    <td width="17" valign="top" bgcolor="#F4F3F3"> 
      
    </td>
    <td width="892" align="left" valign="top"><div align="center">[ <a href="add_schedule1_form.asp">+�������ҧ���¹+</a>]<strong>[<a href=index_schedule.asp>���ҧ���¹������</a>]<br><strong><div align="center">��������´���ҧ���¹<br><br>
	<table align=center border="0">
<%
id_schedule=request("id_schedule")
'id_academic_year=request.form("id_academic_year")
'id_academic_semeter=request.form("id_academic_semeter")
'session("id_stugrou1")=id_stugroup
'session("id_academic_year1")=id_academic_year
'session("id_academic_semeter1")=id_academic_semeter
'id_course_eng=request("id_course_eng")
'response.write id_academic_year
'id_schedule=id_stugroup+id_academic_year+id_academic_semeter
'response.write id_schedule&"aaaaa"

sql_check="select * from course_schedule where id_schedule='"&id_schedule&"'"
set ors_check=server.createobject("adodb.recordset")
ors_check.open sql_check,conn,1,3
if not ors_check.eof then
'response.write "�����ū������"
'�ʴ���ǵ��ҧ���¹
'��������Ե
	sql_stu="select * from student_group where id_stugroup='"&ors_check("id_stugroup")&"'"
	set ors_stu=server.createobject("adodb.recordset")
	ors_stu.open sql_stu,conn,1,3
		if not ors_stu.eof then
					ors_stu.movefirst
					do while not ors_stu.eof

response.write "<tr><td>���ҧ���¹ - �ͺ  �дѺ  "
		
					id_curriculum=ors_stu("id_curriculum")
					sql_curri="select * from curriculum where id_curriculum='"&id_curriculum&"'"
					set ors_curri=server.createobject("adodb.recordset")
					ors_curri.open sql_curri,conn,1,3
					response.write  ors_curri("curriculum_full")&"</td><td>"
					id_major=ors_stu("id_major")
					sql_major="select * from major  where id_major='"&id_major&"'"
					set ors_major=server.createobject("adodb.recordset")
					ors_major.open sql_major,conn,1,3
					response.write ors_major("major_th")&"</td>"

response.write "<td>Ẻ</td><td>"
					id_type_curr=ors_stu("id_type_curri")

set ors_tc=server.createobject("adodb.recordset")
					sqlmark_tc="select * from type_curriculum where id_type_curri='"&id_type_curr&"'"
					ors_tc.open sqlmark_tc,Conn,1,3

response.write ors_tc("type_curri_th")&"</td><td>�Ҥ���¹���  "&ors_check("id_academic_semeter")&"  (�Ҥ"
					sql_end="select * from academic_semeter where id_academic_semeter ='"&ors_check("id_academic_semeter")&"'"
					set ors_end=server.createobject("adodb.recordset")
					ors_end.open sql_end,conn,1,3
					if not ors_end.eof then
					response.write ors_end("academic_semeter")&")</td><td>�ա���֡��  "
					response.write ors_check("id_academic_year")&"</td>"
					end if
					response.write "</tr>"
					ors_stu.movenext
			loop

end if
		end if
		response.write "</table>"
%>

File Manager

Editing: detail_schedule.aspaa