File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>�к����ʹ�����͡�ú�����</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<link href="bsri2006.css" rel="stylesheet" type="text/css">
<link href="image/favicon.ico" rel="shortcut icon" type="image/x-icon">
    <link href="./css/bootstrap.min.css" rel="stylesheet">

#customers td, #customers th {
  border: 0px solid #ddd;
  padding: 8px;
}

#customers th {
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: left;
  background-color: #4CAF50;
  color: white;
}
</style>
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0">
  <tr> 
    <td colspan="2"><div align="right"><img src="Image/head1.gif" width="800" height="61"></div></td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif"><div align="right"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><strong>| 
        <a href="http://www.swu.ac.th" target=_blank>SWU</a> | <a href="http://bsri.swu.ac.th" target=_blank>BSRI</a> 
        |<a href="chaPW.asp"><strong>Change 
        Password</strong></a>|<a href="log_out.asp">Log Out </a></strong></font>|</div></td>
  </tr>
  <tr> 
    <td width="20%" align="left" valign="top" bgcolor="#FFCCCC"></td>
    <td width="77%" align="left" valign="top">
<table width="100%" border="0" cellspacing="0">
    <tr>

<td width="892" align="left" valign="top">
<%
'*****************************************************************

session("tb_name")="student"
%>

<%
id_stu=request("id_stu")
'response.write session("id_stu1") &"aaa"
'response.write "bbb"&id_stu

'*****************************************************************
  'if session("tb_preview") =2 or session("id_stu1") = id_stu  then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ
 pern=session("username")
		  per="2"
		  tb="student"
		  sqlnc="select * from tb_permission where id_staff='"&pern&"' and tb_edit='"&per&"' and tb_name='"&tb&"'"
		  set orsnc=server.createobject("adodb.recordset")
		  orsnc.open sqlnc,conn,1,3
		  
%>
	
	<div align="left">
	<%'if session("tb_edit")	= 2 then %>
	��������´

<%'end if%><br>

<table  border="0" align="left" cellpadding="0" cellspacing="0" width=80%>
            <tr > <td>
             <table border=0 width=100%><tr> <td colspan=3 bgcolor=#FFCC00>��������ǹ���</td>  
			  <%
			  'id_stu=request("id_stu")
			  if id_stu="" then
			  id_stu=session("id_stu1")
			  end if
			  sql_data="select * from student where id_stu='"&id_stu&"' "
	 set ors_data=server.createobject("adodb.recordset")
	 ors_data.open sql_data,conn,1,3
	 if not ors_data.eof then
response.write "<td colspan=2 rowspan=10><div align=center><img src=pic_stu/"&ors_data("pic_stu")&" width=150 ><br>"
if session("tb_edit")=2 or session("username")=id_stu then
			response.write "<div align=center>[<a href=upload_stu_pic_form.asp?id_stu="&id_stu&">����ٻ�Ҿ </a>]<br>(.jpg ���� .png)"	
			end if
response.write "</td></tr>"
%>
            </tr>
            <tr bgcolor=#E9E9E9> 
              <td height="20"><div align="left">���ʹ��Ե</div></td><td>
			  <%
			  response.write id_stu
			  %> </td>
			
            </tr>
           <!-- <tr bgcolor=#E9E9E9> 
              <td><div align="left">���˹觷ҧ������</div></td><td>
			  		<%	  set ors1=server.createobject("adodb.recordset")
	id_administor=ors_data("id_administor")
	 sql="select * from administrator_position where id_administor='"&id_administor&"'"
	 ors1.open sql,Conn,1,3
	ors1.movefirst
		response.write ors1("administor")

%>
			 
            <tr> 
              <td><div align="left">���˹觷ҧ�Ԫҡ��</div></td><td>
<% 
id_academic=ors_data("id_academic")
			  set ors=server.createobject("adodb.recordset")
	 sqlmark="select * from academic_position where id_academic='"&id_academic&"'"
	 ors.open sqlmark,Conn,1,3
	ors.movefirst

response.write ors("academic")&"("&ors("academic_sum")&")"

</tr>
	       <tr bgcolor=#E9E9E9> 
              <td><div align="left">���˹���� �</div></td><td>
<%
id_other_position=ors_data("id_other_position")
'			  set ors_o=server.createobject("adodb.recordset")
'	 sqlmark_o="select * from other_position where id_other_position='"&id_other_position&"'"
'	 ors_o.open sqlmark_o,Conn,1,3
		response.write id_other_position

%>
	
			  
            </tr>-->
            <tr> 
              <td><div align="left">�ӹ�˹��</div></td><td>

<% 
id_preface=ors_data("id_preface")
			  set ors2=server.createobject("adodb.recordset")
	 sql2="select * from preface where id_preface='"&id_preface&"'"
	 ors2.open sql2,Conn,1,3
	 'Response.write sql2
If Not ors2.eof then
		response.write ors2("preface")
End if

</td></tr>
            <tr bgcolor=#E9E9E9> 
              <td><div align="left">����</div></td><td><%=ors_data("name_stu")%> </td>
            </tr>
            <tr> 
              <td><div align="left">���ʡ��</div></td><td><%=ors_data("sur_stu")%> </td>
            </tr>
			  <tr bgcolor=#E9E9E9> 
              <td ><div align="left">Name</div></td><td><%=ors_data("name_eng")%> </td>
            </tr>
            <tr> 
              <td><div align="left">Surname</div></td><td><%=ors_data("sur_eng")%> </td>
            </tr>
	<tr bgcolor=#E9E9E9><td>�������</td><td><%=ors_data("nickname")%></td></tr>
            <tr>
			<td>
			</tr>
            <tr > 
              <td ><div align="left">�ѹ ��͹ ���Դ<td>
			  
                <%=ors_data("bdate_stu")%>
	<tr> <td colspan=3 bgcolor=#FFCC00>��õԴ���</td>
</div></td></tr><tr><td >��Ͷ��<td ><%=ors_data("tell_mobile")%>
<tr bgcolor=#E9E9E9><td>�����ҹ<td><%=ors_data("tell_home")%>
<tr><td >�������<td ><%=ors_data("address_stu")%>
<tr bgcolor=#E9E9E9><td >���˹觧ҹ<td ><%=ors_data("work_position")%>
<tr><td >���ӧҹ<td ><%=ors_data("work_place")%>
<tr bgcolor=#E9E9E9><td >E-mail<td><%=ors_data("email_stu")%>
<tr> <td colspan=3 bgcolor=#FFCC00>����֡��</td>
			<tr> 
              <td ><div align="left" >ʶҹ�Ҿ</div></td><td >
<% 
id_status_edu=ors_data("id_status_edu")
			  set ors3=server.createobject("adodb.recordset")
	 sql3="select * from status_edu where id_status_edu='"&id_status_edu&"'"
	 ors3.open sql3,Conn,1,3
			if not ors3.eof then
		response.write ors3("status_edu")
			end if

%><tr bgcolor=#E9E9E9><td >�ѹ��͹�� ��診����֡��<td ><%=ors_data("d_finish_edu")%>-<%=ors_data("m_finish_edu")%>-<%=ors_data("y_finish_edu")%>(<%=ors_data("f_edu_semeter")%>/<%=ors_data("f_edu_year")%>)

</tr>

<% 
id_stugroup=ors_data("id_stugroup")
			  sql_all="select * from student_group where id_stugroup='"&ors_data("id_stugroup")&"' "
		set ors_all=server.createobject("adodb.recordset")
		ors_all.open  sql_all,Conn,1,3
		if not ors_all.eof Then

id_major=ors_all("id_major")
		response.write ""
			sql_curri="select * from curriculum where id_curriculum='"&ors_all("id_curriculum")&"'"
			set ors_curri=server.createobject("adodb.recordset")
			ors_curri.open sql_curri,conn,1,3
				if not ors_curri.eof then
					id_curriculum=ors_all("id_curriculum")
				response.write  ors_curri("curriculum_full")&" "
				end if
			sqlt="select * from type_curriculum where id_type_curri='"&ors_all("id_type_curri")&"'"
		   set orst=server.createobject("adodb.recordset")
		   orst.open sqlt,conn,1,3
				if not orst.eof then
				response.write orst("type_curri_th")
				end if
					response.write  "  ��� "&ors_all("no_stugroup")
					
				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
					if not ors_major.eof then
						response.write ors_major("major_th")&"</td>"
					end if
		end if
		%>
	
			  
            
		</tr>
	<%
	'Response.write id_major
	If id_major="4" Then
	%>	
	<tr bgcolor=#E9E9E9> 
              <td ><div align="left" ></div></td><td >ᢹ� -
<% 
id_sgroup=ors_data("id_sgroup")
			  set orssg3=server.createobject("adodb.recordset")
	 sqlsg3="select * from student_sgroup where id_sgroup='"&id_sgroup&"'"
	 orssg3.open sqlsg3,Conn,1,3
			if not ors3.eof then
		response.write orssg3("sgroup")
			end if

</tr>
		<%End if%>	
            <tr>
<td align=right><%if session("username")=id_stu or session("tb_edit")=2 then%>
			  [<a href=edit_stu_form.asp?id_stu=<%=id_stu%>>Edit</a>]
			  <%end if%></td>
			  <%if session("tb_edit")=2 then%>
              <td  colspan=3 align=left>[<a href=add_stugroup_form.asp?id_stugroup=<%=ors_data("id_stugroup")%>>�������Ե��蹹��</a>]

[<a href=all_student.asp?id_stugroup=<%=ors_data("id_stugroup")%>>��ª��͹��Ե��蹹��</a>]
			  <%
			  response.write "[<a href=edit_thesis_stu_form.asp?id_stu="&id_stu&">thesis</a>]"
		if id_type_curriculum<>"4" then
			response.write "[<a href=register_sche_indi.asp?id="&id_stu&">����Ԫ�</a>]"
		end if
		if id_curriculum="2" then
			response.write "[<a href=qe_regis.asp?id_stu="&id_stu&">QE</a>]"
		end if
			  %><%end if%>
			  
			  </td></tr><tr><td><td></tr></table>

<!--	  <tr bgcolor=#ffff33><td>�����š��ŧ����¹</td></tr>
			  <tr ><td  >
			  <table border="0" cellspacing="0" align="center" width="100%">
<%

'if ors_data("id_status_edu")=1 then
'response.write "[<a href=course_open.asp?id="&id_stu&">����Ԫҷ����ѧ�Դ�͹</a>]"
'end if
response.write "</td><td ></td>"
							response.write "<tr align=center><td  bgcolor=#BDACBB><strong>���Ѻ </strong><td "&ors_data("id_stugroup")&" bgcolor=#EE7BD7 colspan=2><strong>ŧ����¹��ԧ"
							response.write "<tr bgcolor=#F7C1EC align=center><td  bgcolor=#E2DCE1>����Ԫ�<td width='10%'>�ա���֡��<td width='10%'>�š�����¹"
sqlpe="select * from plan_edu where id_stugroup="&ors_data("id_stugroup")&""
set orspe=server.createobject("adodb.recordset")
orspe.open sqlpe,conn,1,3
a=1
	if not orspe.eof then

orspe.movefirst 
		do while not orspe.eof
		b=a mod 2
if b=0 then
bg2="#E6E6E6"
else bg2="#FCFCFC"
end if	
	a=a+1	
			sqlco="select * from course where id_course='"&orspe("id_course")&"'"
			set orsco=server.createobject("adodb.recordset")
			orsco.open sqlco,conn,1,3
			if not orsco.eof then
				response.write "<tr bgcolor="&bg2&" ><td>"&orsco("id_course_th")&" "&orsco("course_th")
			end if
				sqlt="select * from course_regis where id_student='"&id_stu&"' and id_course='"&orspe("id_course")&"'"
				set orst=server.createobject("adodb.recordset")
				orst.open sqlt,conn,1,3
				
				if not orst.eof then

orst.movefirst
					do while not orst.eof 
					
						sqlse="select * from course_schedule where id_schedule='"&orst("id_schedule")&"'"
						set orsse=server.createobject("adodb.recordset")
						orsse.open sqlse,conn,1,3
							response.write "<td>"
							if not orsse.eof then
							response.write orsse("id_academic_semeter")&"/"&orsse("id_academic_year")
							end if
						sqlc="select * from course where id_course='"&orst("id_course")&"'"
						set orsc=server.createobject("adodb.recordset")
						orsc.open sqlc,conn,1,3
								if not orsc.eof then
											sql_g="select * from grade where id_grade='"&orst("grade")&"'"
											set ors_g=server.createobject("adodb.recordset")
											ors_g.open sql_g,conn,1,3
											if not ors_g.eof then
											if session("type_login")<>2 then
					response.write "<td>"&ors_g("ngrade")
					else response.write "<td>"
										end if
											end if
								end if
					
				orst.movenext
							loop
				else 
				response.write "<td colspan=2>-"
				end if
				orspe.movenext
loop
else
response.write "<tr><td>No Educate Plan"
	end if
'����Ԫҷ�����¹������������Ѻ
response.write "<tr bgcolor=#C0C0C0><td colspan=3 align=center>�Ԫ����͡ 2 �Ԫ� 6 ˹��¡Ե"
				sqlt8="select * from course_regis where id_student='"&id_stu&"'"
				set orst8=server.createobject("adodb.recordset")
				orst8.open sqlt8,conn,1,3
				
				if not orst8.eof then

orst8.movefirst
					do while not orst8.eof 
					       sqlpe8="select * from plan_edu where id_stugroup="&ors_data("id_stugroup")&" and id_course='"&orst8("id_course")&"'"
							set orspe8=server.createobject("adodb.recordset")
							orspe8.open sqlpe8,conn,1,3
							a=1
					if orspe8.eof then
								sqlse8="select * from course where id_course='"&orst8("id_course")&"'"
								set orsse8=server.createobject("adodb.recordset")
								orsse8.open sqlse8,conn,1,3

response.write "<tr >"
								response.write "<td >"&orsse8("id_course_th")&" "&orsse8("course_th")&" "&orsse8("credit")
								sql9="select * from course_category where id_course='"&orsse8("id_course")&"'"
								set ors9=server.createobject("adodb.recordset")
							ors9.open sql9,conn,1,3
							if not ors9.eof then
									id_category=ors9("id_category")
									sql10="select * from category_course where id_category='"&ors9("id_category")&"'"
									set ors10=server.createobject("adodb.recordset")
									ors10.open sql10,conn,1,3
									if not ors10.eof then
											response.write "-"&ors10("category")
									end if
							end if
						sqlc8="select * from course_schedule where id_schedule='"&orst8("id_schedule")&"'"
						set orsc8=server.createobject("adodb.recordset")
						orsc8.open sqlc8,conn,1,3
								if not orsc8.eof then
									response.write "<td>"&orsc8("id_academic_semeter")&"/"&orsc8("id_academic_year")
								end if
								
								sqlgrade="select * from course_regis where id_student='"&id_stu&"' and id_course='"&orst8("id_course")&"'"
								set orsgrade=server.createobject("adodb.recordset")
								orsgrade.open sqlgrade,conn,1,3
									if not orsgrade.eof then
												sql_g="select * from grade where id_grade='"&orsgrade("grade")&"'"
												set ors_g=server.createobject("adodb.recordset")
												ors_g.open sql_g,conn,1,3
												if not ors_g.eof then
												
												 if session("type_login")<>2 then
													response.write "<td>"&ors_g("ngrade")
													end if
												end if
									end if
								end if
									orst8.movenext
								loop
					else 
					'response.write "<td colspan=2>-"
					end if

'end if '��Ǩ�ͺ�����բ����Ź��Ե��������
	
	%>

</table>

</td></tr>-->

<tr bgcolor=#FFCC00><td >�����š�÷ӻ�ԭ�ҹԾ���</td></tr>
<tr ><td  >
				<table border="0"><tr><td colspan="6" width="100%">
				<table border="0" cellspacing="0" width="100%">
                              
                            
				<%
				sqla="select * from advisor_thesis where id_stu='"&id_stu&"' order by id_num"
				set orsa=server.createobject("adodb.recordset")
				orsa.open sqla,conn,1,3
							  
				if not orsa.eof then
				response.write  "<tr><td colspan=5 bgcolor=#ffffcc><div align=left><strong>�Ҩ�������֡��</div></td></tr>"
				response.write  "<tr bgcolor=#E1E1E1>" 
				response.write  "  <td><div align=center><strong></strong>�ӴѺ���</div></td>"
                response.write  "  <td><div align=center><strong></strong>���˹�</div></td>"
                response.write  "  <td width=150><div align=center><strong>����-ʡ��</strong></div></td>"
								' response.write  "<td width=150><div align=left><strong>����-ʡ��(��¹͡)</strong></div></td>"
				response.write  "  <td ><div align=center><strong>�Ţ�������</strong></div></td>"
				response.write  "<td ><div align=center><strong>������ѹ���</strong></div></td>"
                response.write  "</tr>"
					idn=0
					orsa.movefirst
							   
				do while not orsa.eof
				response.write "<tr><td>"&orsa("id_num")
				sqlp="select * from position_advice where id_position='"&orsa("id_position_thesis")&"'"
				set orsp=server.createobject("adodb.recordset")
				orsp.open sqlp,conn,1,3
							  						  
				if not orsp.eof then
				response.write "<td >"&orsp("position_advice")
				end if
				sqll="select * from lecturer where id_lecturer='"&orsa("id_lecturer")&"' "
				set orsl=server.createobject("adodb.recordset")
				orsl.open sqll,conn,1,3
				if not orsl.eof then
				if orsa("id_lecturer")="000" then
					response.write "<td >"&orsa("advisor_out")&"(��¹͡)"
				else 
					response.write "<td>"&orsl("name_lec")&"  "&orsl("sur_lec")
				end if
					if not orsnc.eof or id_stu=session("id_stu1") then
														
					end if
				end if
					response.write "<td>"&orsa("command_no")
					response.write "<td>"&orsa("command_date")
					response.write "/"&orsa("command_month")
					response.write "/"&orsa("command_year")&"</tr>"
			idn=orsa("id_num")
			orsa.movenext
				loop
			else
				response.write "<tr><td colspan=4>�Ҩ�������֡�һ�ԭ�ҹԾ��� -��͡������դ�����觵���Ҩ�������֡��</tr>"
				idn=0
			end if
				response.write "</td></tr></table>"

sqlt="select * from thesis where id_stu='"&id_stu&"'"
				set orst=server.createobject("adodb.recordset")
				orst.open sqlt,conn,1,3
				if not orst.eof then
							response.write "<tr bgcolor=#E1E1E1><td><strong>���ʻ�ԭ�ҹԾ���<td width=200><strong>���ͻ�ԭ�ҹԾ��� </strong>"
							'if not orsnc.eof then
							'response.write "<div align=center>Action"
							'end if
							orst.movefirst
							do while not orst.eof 
				'����ջ�ԭ�ҹԾ���
id_thesis=orst("id_thesis")
							response.write "<tr >"
							response.write "<td>"&orst("id_thesis")
							response.write "<td >-"&orst("thesis_th")&"<br><li>"&orst("thesis_eng")
							'response.write "<td>"&orst("id_course")
							'response.write "<td>"&orst("id_academic_semeter")&"/"&orst("academic_year")

'response.write "<td>[<a href=add_advisor_thesis_form.asp?id_thesis="&orst("id_thesis")&"&id_stu="&orst("id_stu")&">��������´  </a>]"
							'response.write "<td>[<a href=reserve_room_test_form.asp?id_thesis="&orst("id_thesis")&"&id_stu="&orst("id_stu")&">�ͧ</a>]"
							'response.write "[<a href=reserve_room_test_print.asp?id_thesis="&orst("id_thesis")&"&id_stu="&orst("id_stu")&">�����</a>]"
							'if not orsnc.eof then
							'response.write "<td>"
						'response.write "[ <a href=edit_thesis_form.asp?id_thesis="&orst("id_thesis")&"&id_stu="&orss("id_stu")&">Edit</a> ]"
							
							%>
							
							<%
							'end if

orst.movenext
							loop
				else 
				response.write "<tr><td>���ͻ�ԭ�ҹԾ��� -��͡������դ�����ͺ����ç"
				end if
%>
				</table>

<table width="100%" border="0">
<tr> 
<%			sqlt_test="select * from thesis_test where id_thesis='"&id_thesis&"' and id_type_test='1' "
			set orst_test=server.createobject("adodb.recordset")
		orst_test.open sqlt_test,conn,1,3
			if not orst_test.eof then
			orst_test.movefirst%>
                                <td colspan="3" bgcolor="#ffffcc"><div align="left"><strong>��С�������ͺ����ç<%=orst_test("date1")&"/"&orst_test("month1")&"/"&orst_test("year1")%></div></td>
                              </tr>
                                  <tr bgcolor="#EBEBEB"> 
							    <td><div align="center"><strong></strong>�ӴѺ���</div></td>
                                <td><div align="center"><strong></strong>���˹�</div></td>
                                <td ><div align="center"><strong>����-ʡ��</strong></div></td>
								
                              </tr>
                              <tr> 
							  <%
'�ç������㹵��ҧ thesis_test �����ʴ��¡��������ͺ������ç��лҡ����
ab=0
			do while not orst_test.eof
			ab=ab+1
			response.write "<tr bgcolor=#FFFFCC><td colspan=3 >����ͺ���駷�� "&ab
			id=orst_test("id")
							  sqla="select * from committee_thesis where id_thesis='"&id_thesis&"' and id='"&id&"' order by id_num"
							  set orsa=server.createobject("adodb.recordset")
							  orsa.open sqla,conn,1,3
							  if not orsa.eof then
							  orsa.movefirst
								
							  do while not orsa.eof
							  response.write "<tr><td align=right>"&orsa("id_num")
							  sqlp="select * from position_thesis where id_position_thesis='"&orsa("id_position_thesis")&"'"
							  set orsp=server.createobject("adodb.recordset")
							  orsp.open sqlp,conn,1,3
							  						  
							  if not orsp.eof then
							  response.write ".<td>"&orsp("position_thesis")
							  end if
							  sqll="select * from lecturer where id_lecturer='"&orsa("id_lecturer")&"' "
							  set orsl=server.createobject("adodb.recordset")
							  orsl.open sqll,conn,1,3
							  if not orsl.eof then
									if orsa("id_lecturer")="000" then
										response.write "<td >"&orsa("oral_out")&"(��¹͡)"
									else
									response.write "<td>"&orsl("name_lec")&"  "&orsl("sur_lec")
									 end if
									if not orsnc.eof then
									%>
									[<a href=del_committee_thesis.asp?id_lecturer=<%=orsa("id_lecturer")&"&id_thesis="&id_thesis&"&id_stu="&id_stu%> 
									onclick="return confirm('�س�����Ҩ�ź?');">Del</a>]
									
									<%end if
							  end if
								'response.write "<td >"&orsa("oral_out")
							  orsa.movenext
							  loop
							  else
							  response.write "<tr><td colspan=3>No Committee</tr>"
							  
							  end if

orst_test.movenext
				  loop
				'  response.write "<tr><td colspan=3>end of data</tr>"
				  end if %>
<tr > 
<%sqlt_test="select * from thesis_test where id_thesis='"&id_thesis&"' and id_type_test='2' "
			set orst_test=server.createobject("adodb.recordset")
		orst_test.open sqlt_test,conn,1,3
			if not orst_test.eof then
			orst_test.movefirst%>
                                <td colspan="3" bgcolor="#ffffcc"><div align="left"><strong>��С�������ͺ�ҡ����<%=orst_test("date1")&"/"&orst_test("month1")&"/"&orst_test("year1")%></div></td>
                              </tr>
                                  <tr bgcolor="#EBEBEB"> 
							    <td><div align="center"><strong></strong>�ӴѺ���</div></td>
                                <td><div align="center"><strong></strong>���˹�</div></td>
                                <td ><div align="left"><strong>����-ʡ��</strong></div></td>
								
                              </tr>
                              <tr> 
							  <%
							  '��С�������ͺ�ҡ����
'�ç������㹵��ҧ thesis_test �����ʴ��¡��������ͺ������ç��лҡ����
			
			do while not orst_test.eof
			id=orst_test("id")
							  sqla="select * from committee_thesis where id_thesis='"&id_thesis&"' and id='"&id&"' order by id_num"
							  set orsa=server.createobject("adodb.recordset")
							  orsa.open sqla,conn,1,3
							  if not orsa.eof then
							  orsa.movefirst
								
							  do while not orsa.eof
							  response.write "<tr><td>"&orsa("id_num")
							  sqlp="select * from position_thesis where id_position_thesis='"&orsa("id_position_thesis")&"'"
							  set orsp=server.createobject("adodb.recordset")
							  orsp.open sqlp,conn,1,3
							  						  
							  if not orsp.eof then
							  response.write "<td>"&orsp("position_thesis")
							  end if
							  sqll="select * from lecturer where id_lecturer='"&orsa("id_lecturer")&"' "
							  set orsl=server.createobject("adodb.recordset")
							  orsl.open sqll,conn,1,3
							  if not orsl.eof then
									if orsa("id_lecturer")="000" then
											response.write "<td >"&orsa("oral_out")&"(��¹͡)"
									else
										response.write "<td>"&orsl("name_lec")&"  "&orsl("sur_lec")
									end if
									if not orsnc.eof then
									%>
									[<a href=del_committee_thesis.asp?id_lecturer=<%=orsa("id_lecturer")&"&id_thesis="&id_thesis&"&id_stu="&id_stu%> 
									onclick="return confirm('�س�����Ҩ�ź?');">Del</a>]
									
									<%end if
							  end if
								'response.write "<td >"&orsa("oral_out")
							  orsa.movenext
							  loop
							  else
							  response.write "<tr><td colspan=3>No Committee</tr>"
							  
							  end if

orst_test.movenext
				  loop
				 ' response.write "<tr><td colspan=4>end of data</tr>"
				  
				  end if
'�����С�������ͺ�ҡ����
							  %>
							  </table>
			  
			  </td></tr>
<%

end if
%>

</td></tr>

</table>

</td></tr>  
      </div></td>
    
	</tr>
           </table>
		     <%	'else '���Է�
	'response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
'response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է�
	'end if '���Է�
%>

</td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif">Contact Admin:: wassanaw@swu.ac.th 
      tel.02-649-5000 ext 17600</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: detail_stu.asp.bak