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")="course"
%>

<%
	response.write "<div align=center><table >"
	response.write "<tr><td colspan=3><div align=center><strong>����ԪҡѺ��Ҩ�������͹"

response.write session("tb_edit")
'*****************************************************************
  'if session("tb_preview") = 2  then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

%>
<%
id_course_eng=request("id_course_eng")
id_course=request("id_course")
sql="select * from course_schedule2 where id_course='"&id_course&"'"
set ors=server.createobject("adodb.recordset")
ors.open sql,conn,1,3
if not ors.eof then
		sql_c="select * from course where id_course='"&id_course&"'"
		set ors_c=server.createobject("adodb.recordset")
		ors_c.open sql_c,conn,1,3
				if not ors_c.eof then
				response.write "<tr><td colspan=3><div align=center>������Ъ����Ԫ�"&id_course_eng&" "&ors_c("course_th")&"<br>("&ors_c("course_eng")&") "&ors_c("credit")
				end if
					
						response.write "<tr bgcolor=#EFEDED><td><div align=center><strong>���ʼ���͹<td><div align=center><strong>����-ʡ��<td><div align=center><strong>�ա���֡��"
						
						ors.movefirst
						do while not ors.eof 		
						sql_l="select * from lecturer where id_lecturer='"&ors("id_lecturer")&"'"
								set ors_l=server.createobject("adodb.recordset")
								ors_l.open sql_l,conn,1,3
										if not ors_l.eof then
											response.write "<tr><td>"&ors_l("id_lecturer")&"<td>�."&ors_l("name_lec")&" "&ors_l("sur_lec")
										sql_s="select * from course_schedule where id_schedule='"&ors("id_schedule")&"'"
													set ors_s=server.createobject("adodb.recordset")
													ors_s.open sql_s,conn,1,3
													if not ors_s.eof then
													response.write "<td>"&ors_s("id_academic_year")&"/"&ors_s("id_academic_semeter")
													end if
					end if
								'response.write "<tr><td>"&ors
						ors.movenext
						loop
		else  response.write "<tr><td colspan=3>�ѧ������Դ�͹</td></tr>"				
end if
%>
	    <%	'else '���Է�
	'response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
'response.write "<meta http-equiv=refresh content =4;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: course_lec.asp