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">
</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"
%>

<%
'*****************************************************************
'  if session("tb_preview") <> 1  then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

%>
	<div align="center"><font size=2><strong>
	<%if session("tb_edit")=2 then%>[<a href=add_group_form.asp>+���ҧ��蹹��Ե+</a>]
	<%end if%><br> ���������<br> <br><br>
	<table>
	<%	
id_stugroup=request("id_stugroup")
	if id_stugroup ="" then
	id_stugroup=session("id_stugroup")
	'id_lecturer=4
	end if
	sqlall="select * from student_group where id_stugroup="&id_stugroup&""
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
	if not orsall.eof then
response.write "<tr><td>������� </td><td>"&id_stugroup&"</td></tr>"
      'sql_admin="select * from administrator_position where id_administer ="&orsall("id_administer")&""
	  'set ors_admin=server.createobject("adodb.recordset")
	  'ors_admin.open sql_admin,conn,1,3
response.write "<tr><td>��蹷��</td><td>"&orsall("no_stugroup")&"</td></tr>"
	  'sql_academic="select * from academic_position where id_academic ="&orsall("id_academic")&""
	  'set ors_academic=server.createobject("adodb.recordset")
	  'ors_academic.open sql_academic,conn,1,3
response.write "<tr><td>�ա���֡�ҷ����������¹</td><td>"&orsall("id_begin_year")&" �Ҥ "
begin_sem=orsall("id_begin_semeter")
sql_sem="select * from academic_semeter where id_academic_semeter ="&begin_sem&""
	  set ors_sem=server.createobject("adodb.recordset")
	  ors_sem.open sql_sem,conn,1,3
response.write ors_sem("academic_semeter")&"</td></tr>"
response.write "<tr><td>�ա���֡�ҷ���ͧ��</td><td>"&orsall("id_end_year")&" �Ҥ "
end_semeter=orsall("id_end_semeter")
sql_end="select * from academic_semeter where id_academic_semeter ="&end_semeter&""
	  set ors_end=server.createobject("adodb.recordset")
	  ors_end.open sql_end,conn,1,3
response.write ors_end("academic_semeter")&"</td></tr>"
      sql_o_po="select * from curriculum where id_curriculum="&orsall("id_curriculum")&""
	  set ors_o_po=server.createobject("adodb.recordset")
	  ors_o_po.open sql_o_po,conn,1,3
response.write "<tr><td>�дѺ��ѡ�ٵ�</td><td>"&ors_o_po("curriculum_full")&"</td></tr>"

response.write "<tr><td>	 Ẻ</td><td>"
id_type_curr=orsall("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></tr>"
		
		
      sql_pre="select * from education_bg where id_edu_bg="&orsall("id_edu_bg")&""
	  set ors_pre=server.createobject("adodb.recordset")
	  ors_pre.open sql_pre,conn,1,3		
response.write "<tr><td>�زԡ���֡��</td><td>"&ors_pre("edu_th_full")&"</td></tr>"			 
      sql_sta="select * from major where id_major="&orsall("id_major")&""
	  set ors_sta=server.createobject("adodb.recordset")
	  ors_sta.open sql_sta,conn,1,3
response.write "<tr><td>�Ԫ��͡</td><td>"&ors_sta("major_th")&"</td></tr>"
		sqlad="select * from advisor_student where id_stugroup='"&id_stugroup&"'"
		set orsad=server.createobject("adodb.recordset")
		orsad.open sqlad,conn,1,3
		if not orsad.eof then
		orsad.movefirst
		do while not orsad.eof 
				sqllec="select * from lecturer where id_lecturer='"&orsad("id_lecturer")&"'"
				set orslec=server.createobject("adodb.recordset")
				orslec.open sqllec,conn,1,3
				if not orslec.eof then
					orslec.movefirst
					do while not orslec.eof
						response.write "<tr><td>�Ҩ�������֡��</td><td>[<a href=detail_lec.asp?id_lecturer="&orsad("id_lecturer")&">"&orslec("name_lec")&"   "&orslec("sur_lec")&"</a>]</td></tr>"
						orslec.movenext
						loop
				end if
orsad.movenext
loop
end if
''''���ͨӹǹ���Ե
sqlstu="select * from student where id_stugroup='"&orsall("id_stugroup")&"'"
set orsstu=server.createobject("adodb.recordset")
orsstu.open sqlstu,conn,1,3
a=0
if not orsstu.eof then
orsstu.movefirst
do while not orsstu.eof
a=a+1
orsstu.movenext
loop

end if
''''���ͨӹǹ���Ե
response.write "<tr><td>[<a href=all_student.asp?id_stugroup="&id_stugroup&">��ª��͹��Ե</a>] �ӹǹ  "&a&"  �� </td></tr>"	
'response.write "<td><div align=right>[<a href=edit_stugroup_form.asp?id_stugroup="&orsall("id_stugroup")&">Edit</a>]</td></tr>"

end if
	%>

</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 '���Է�
%>

</table>

</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_stugroup.asp.bak