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

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

<%
'*****************************************************************
'response.write id_lecturer
  if session("tb_preview") <> 1 or session("id_lecturer1") = id_lecturer then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

<table width="100%" border="0" cellspacing="0">
  
  <tr> 
    
    <td width="892" align="left" valign="top" ><div align="center"><font size=2><strong>
	<%if session("tb_edit")=2 then%>[<a href=add_stu_form.asp>+��������������Ԫ�+</a>] [<a href=indexstudent.asp>�ʴ������Ź��Ե������</a>]<%end if%><br>�ʴ�����ԪҡѺ����͹ <br><br>
	<table border=0>
	<%	
id_category=request("id_category")
	sqlall="select * from category_course where id_category='"&id_category&"'"
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof then
		'do while not orsall.eof
   
response.write "<tr><td bgcolor=#AEAEAE><strong>"&orsall("id_category")&"</td><td colspan=7 bgcolor=#AEAEAE><strong>"&orsall("category_group")
response.write " <strong> "&orsall("category")&""&orsall("category_group_name")&"</td></tr>"
response.write "<tr><td><td colspan=2 bgcolor=#D6D6D6><strong>����Ԫҷ���������Ǵ   </td>"
'response.write "<td bgcolor=#D6D6D6><strong>�ӹǹ   </td>"
response.write "</tr>"
sqlc1="select * from course_category where id_category='"&orsall("id_category")&"'"
set orsc1=server.createobject("adodb.recordset")
orsc1.open sqlc1,conn,1,3
if not orsc1.eof then
         orsc1.movefirst
		 do while not orsc1.eof
		 response.write "<tr>"

sqlco="select * from course where id_course='"&orsc1("id_course")&"'"
		 set orsco=server.createobject("adodb.recordset")
		 orsco.open sqlco,conn,1,3

if not orsco.eof then
 response.write "<td><td colspan=2 bgcolor=#E5E5E5>"&orsco("id_course_th")&" "&orsco("course_th")&"</td></tr>"
		 sqll="select * from course_schedule order by id_academic_year ,id_academic_semeter desc"
		 set orsl=server.createobject("adodb.recordset")
		 orsl.open sqll,conn,1,3
			if not orsl.eof then
			orsl.movefirst
  i=0
do while not orsl.eof

sqlc="select * from  course_schedule2 where id_course='"&orsc1("id_course")&"'and id_schedule='"&orsl("id_schedule")&"' "
set orsc=server.createobject("adodb.recordset")
orsc.open sqlc,conn,1,3

if not orsc.eof then
	 i=i+1
		'do while not orsc.eof
		response.write "<tr><td><td><td>("&i&".)"&orsl("id_academic_year")&"/ "&orsl("id_academic_semeter")&"</td>"
	
		'response.write "<td ><strong>���   "&i&"   ����</td>"
		response.write "</tr>"
end if'orsc

orsl.movenext
loop

end if'orsl

end if'orsco

orsc1.movenext
		loop

end if'orsc1
		
'orsall.movenext
'loop

end if
	%>

</div></td>
	</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_course_lec2.asp.bak