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

<%
'*****************************************************************
  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_lec_form.asp>+�����������Ҩ����+</a>] [<a href=all_lecturer.asp>�ʴ��������Ҩ���������</a>]<%end if%><br>�ʴ�����Ԫҷ�褳Ҩ�������з�ҹ�͹ <br><br>
	<table>
	<%	
    i=0
	sqlall="select * from lecturer where statusdel =1 order by name_lec"
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof then
		do while not orsall.eof
'response.write "<td>���ʻ�Шӵ�� </td><td>"&orsall("id_lecturer")&"</td>"
 i=i+1
 if i mod 2 =0 then
bg1="#EAEAEA"
else bg1="#FBFBFB"
 end if
response.write "<tr bgcolor="&bg1&"><td>"&i&"<td><strong>�.</td><td><strong>"&orsall("name_lec")
response.write " <strong> "&orsall("sur_lec")&"</td>"
response.write "<td>[<a href=detail_lec_course2.asp?id_lecturer="&orsall("id_lecturer")&">����Ԫҷ���͹</a>]   </td></tr>"
']]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
'sqlc1="select * from course"
'set orsc1=server.createobject("adodb.recordset")
'orsc1.open sqlc1,conn,1,3
'if not orsc1.eof then
 '        orsc1.movefirst
'		 do while not orsc1.eof
'sqlc="select * from course_schedule2 where id_lecturer='"&orsall("id_lecturer")&"' and id_course_eng='"&orsc1("id_course_eng")&"'"
'set orsc=server.createobject("adodb.recordset")
'orsc.open sqlc,conn,1,3

'if not orsc.eof then

'	 sqlt="select * from course where id_course_eng='"&orsc("id_course_eng")&"'"
	'	 set orst=server.createobject("adodb.recordset")
	'	 orst.open sqlt,conn,1,3
	'	 if not orst.eof then
	'	 i=i+1
	'		sqlcc="select * from course_category where id_course ='"&orsc("id_course_eng")&"'"
	'		set orscc=server.createobject("adodb.recordset")
	'		orscc.open sqlcc,conn,1,3
	'			if not orscc.eof then
	'			    sqlccc="select * from category_course where id_category	='"&orscc("id_category")&"'"
	'				set orsccc=server.createobject("adodb.recordset")
	'				orsccc.open sqlccc,conn,1,3
	'				if not orsccc.eof then
	'			response.write "<tr><td></td><td> "&orst("id_course_th")&""&orst("course_th")&"<td> "&orsccc("category")&"</td></tr>"
	'				end if
	'			end if
	'	 end if
		
	
	'	end if
	'	orsc1.movenext
	'	loop
	'	end if
	'	response.write "<tr><td colspan =3><strong>���   "&i&"   ����Ԫ�</td></tr>"
		']]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]
orsall.movenext
loop

end if
	%>

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