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

</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">SWU</a> | <a href="http://bsri.swu.ac.th">BSRI</a> 
        |<a href="log_out.asp">Log Out </a></strong></font>|</div></td>
  </tr>
  <tr bgcolor="#FFCCCC"> 
    <td width="14%">&nbsp;</td>
    <td> <div align="right"></div>
      <div align="center"></div></td>
  </tr>
  <tr> 
    <td align="left" valign="top" background="Image/menu_5.gif"></td>
    <td align="left" valign="top">
<table width="100%" border="0" cellspacing="0">
<%
'*****************************************************************

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

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

<tr> 
    
    <td width="892" align="left" valign="top"><div align="center">
	<%
	if session("tb_edit")=2 then
	%>[ <a href="add_curri_form.asp">+������ѡ�ٵ�+</a>]<br><strong>���͡��ѡ�ٵá�˹�Ἱ������¹<%end if%><br><br>
	<table align=center>
	<tr>
	<td><strong>�дѺ</td>	<td><strong>Ẻ</td>	<td><strong>�زԡ���֡��</td>	<td><strong>�Ң�</td><td><strong>Action</td>
<%
sqlall="select * from curriculum_manage"
set orsall=server.createobject("adodb.recordset")
orsall.open sqlall,conn,1,3
if not orsall.eof then
orsall.movefirst
do while not orsall.eof
id_curriculum=orsall("id_curriculum")

sql_o_po="select * from curriculum where id_curriculum='"&id_curriculum&"'"

set ors_o_po=server.createobject("adodb.recordset")
	  ors_o_po.open sql_o_po,conn,1,3
	  if not ors_o_po.eof then
response.write "<tr><td>"&orsall("id_curriculum_manage")&""&ors_o_po("curriculum_full")&"</td>"

response.write "<td>"
id_type_curr=orsall("id_type_curri")

set ors_tc=server.createobject("adodb.recordset")
	 sqlmark_tc="select * from type_curriculum where id_type_curri='"&id_type_curr&"'"
	 ors_tc.open sqlmark_tc,Conn,1,3
if not ors_tc.eof then
		response.write ors_tc("type_curri_th")&"</td>"
		id_edu_bg=orsall("id_edu_bg")
		
     sql_pre="select * from education_bg where id_edu_bg='"&id_edu_bg&"'"
	  set ors_pre=server.createobject("adodb.recordset")
	  ors_pre.open sql_pre,conn,1,3		
	  if not ors_pre.eof then
response.write "<td>"&ors_pre("edu_th_full")&"</td>"	
id_major=orsall("id_major")
     sql_sta="select * from major where id_major='"&id_major&"'"
	  set ors_sta=server.createobject("adodb.recordset")
	  ors_sta.open sql_sta,conn,1,3
	  if not ors_sta.eof then
response.write "<td>"&ors_sta("major_th")&"</td><td>[<a href=choose_category_sp.asp?id_curriculum_manage="&orsall("id_curriculum_manage")&">���͡</a>]</td></tr>"
end if
end if
end if
end if
orsall.movenext
loop
conn.close

else
response.write "No Curriculum"
end if
%>

</tr>
	</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>

</table>

| 
        <a href="index_academic.asp">�ҹ�Ԫҡ�� </a>| �ҹ�Ԩ�� | �ҹ��ԡ���Ԫҡ�� 
        | �ҹʹѺʹع�Ԫҡ�� |</td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif">&nbsp;</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: study_plan.asp.bak