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> 
<%
'*****************************************************************

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

<%
'*****************************************************************
  if session("tb_edit") =2  then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

<td width="892" align="left" valign="top"><div align="center"><font size=2><strong> [��ª��͹��Ե������]<br><br>
	<table>
	<%
	id_stugroup=request("id_stugroup")
	sql_group="select * from student_group where id_stugroup='"&id_stugroup&"'"
	set ors_group=server.createobject("adodb.recordset")
	ors_group.open sql_group,conn,1,3
'	ors_group.movefirst
'	do while not ors_group.eof 
	%>
	
	<tr><td><strong>��ѡ�ٵ�
	<%
	'response.write ors_group("id_curriculum")
	id_curriculum=ors_group("id_curriculum")
	'response.write 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>"
	%></td><td><strong>Ẻ
	<%
	id_type_curriculum=ors_group("id_type_curri")
	set ors_tc=server.createobject("adodb.recordset")
	 sqlmark_tc="select * from type_curriculum where id_type_curri='"&id_type_curriculum&"'"
	 ors_tc.open sqlmark_tc,Conn,1,3
		response.write ors_tc("type_curri_th")
	%>
	
	</td><td><strong>��蹷��
	<%
	response.write ors_group("no_stugroup")
	%>
	
	</td></div><td ><strong>�Ң�
	<%
	id_major=ors_group("id_major")
	set ors5=server.createobject("adodb.recordset")
	 sql5="select * from major where id_major='"&id_major&"'"
	 ors5.open sql5,Conn,1,3
	ors5.movefirst
		response.write ors5("major_th")
	%>
	</td></tr>
	<%
	id_stugroup=ors_group("id_stugroup")
	sqlall="select * from student where id_stugroup='"&id_stugroup&"'"
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof then
		orsall.movefirst
		do while not orsall.eof
		response.write "<tr><td>[<a href=detail_stu.asp?id_stu="&orsall("id_stu")&">"&orsall("id_stu")&"</a>]</td><td>"&orsall("name_stu")&"  "&orsall("sur_stu")&"</td><td>"
				if session("tb_edit") = 2 then

response.write "[<a href=edit_stu_form.asp?id_stu="&orsall("id_stu")&">Edit</a>]</td>"
		end if
		
		orsall.movenext
		loop
		else
		response.write "<tr><td>No Student</td></tr>"
		end if
'		ors_group.movenext
'		loop
	%>
	</table></div></td>
       <%	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: stu_ingroup.asp.bak