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="1" align="center" cellspacing="0" bordercolor="#999999">
	
	
	<%
'*****************************************************************

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

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

%>
<%
response.write "<tr><td colspan=6><div align=center><strong>������³���ءѺ�زԡ���֡��" 
response.write "<tr bgcolor=#EDEBEB><td rowspan=2><div align=center><strong>����<td rowspan=2><div align=center><strong>����-ʡ��<td colspan=3><div align=center><strong>�زԡ���֡��<td rowspan=2><strong><div align=center>�շ�����³"
response.write "<tr bgcolor=#EDEBEB><td><div align=center><strong>�͡<td><div align=center><strong>�<td><div align=center><strong>���"
sqlall="select * from lecturer where id_status_lec=1 order by year_retire asc"
		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_lec.asp?id_lecturer="&orsall("id_lecturer")&">"&orsall("id_lecturer")&"</a>]</td><td>"&orsall("name_lec")&"  "&orsall("sur_lec")&"</td>"
							
									sqlc="select * from curriculum"
									set orsc=server.createobject("adodb.recordset")
									orsc.open sqlc,conn,1,3
									if not orsc.eof then
										orsc.movefirst
										do while not orsc.eof
											sqle="select * from education_vita where id_staff='"&orsall("id_lecturer")&"'and id_curriculum='"&orsc("id_curriculum")&"'"
											set orse=server.createobject("adodb.recordset")
											orse.open sqle,conn,1,3
													if not orse.eof then
													orse.movefirst
													response.write "<td>"
													do while not orse.eof 
															'sqleb="select * from education_bg where id_edu_bg='"&orse("id_edu_bg")&"'"
															'set orseb=server.createobject("adodb.recordset")
															'orseb.open sqleb,conn,1,3
															'		if not orseb.eof then
																	response.write orse("id_edu_bg_t")
																'			sqlm="select * from major where id_major ='"&orse("id_edu_major")&"'"
																'			set orsm=server.createobject("adodb.recordset")
																'			orsm.open sqlm,conn,1,3
																'				if not orsm.eof then

response.write "<br>("&orse("id_major_t")	&")<br>"
																	'			end if
																	'end if
																
													orse.movenext
													'response.write "<br>"
													loop
													else
															response.write "<td>"'�������յ���زԹ�� �� ������ز� �.� ������ҧ��ͧ��� �� �
													end if

orsc.movenext
										loop
									end if
					
					response.write "<td>"&orsall("year_retire")
					response.write "</tr>"

orsall.movenext
		loop
		end if

<%	else '���Է�
	response.write "<tr><td colspan=6><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: lec_edu.asp