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="0" cellspacing="0">
    <%

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

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

<tr> 
    <td colspan="3"> </td>
  </tr><tr>
  
  <td width="892" align="left" valign="top"><div align="center">
  <%if session("tb_edit")=2 then%>[ <a href="add_curri_form.asp">+������ѡ�ٵ�+</a>]<%end if%><br><strong> 
      ��͡��������´Ἱ������¹<br>
      <br>
      <table align=center>
        <tr> 
          <%
id_curriculum_manage=request("id_curriculum_manage")
session("id_curriculum_manage")=id_curriculum_manage
sqlall="select * from curriculum_manage where id_curriculum_manage='"&id_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
response.write "<tr><td>"&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

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		
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
response.write "<td>�Ң�"&ors_sta("major_th")&"</td></tr>"

sql_a="select * from category_course"
set ors_a=server.createobject("adodb.recordset")
ors_a.open sql_a,conn,1,3
if not ors_a.eof then
ors_a.movefirst
do while not ors_a.eof
response.write "<tr><td colspan=3>-"&ors_a("category_group")&""&ors_a("category_group_name")&"   �Ԫ�"&ors_a("category")&"  </td><td>      [      <a href=choose_category.asp?id_curriculum_manage="&id_curriculum_manage&"&id_category="&ors_a("id_category")&">   ����Ԫ�</a>     ]</td></tr>"

'sql_sl="select * from course_category where id_category='"&ors_a("id_category")&"'"
'	set ors_sl=server.createobject("adodb.recordset")
'	ors_sl.open sql_sl,conn,1,3
'	if not ors_sl.eof then
'	ors_sl.movefirst
'	do while not ors_sl.eof
'		response.write "<tr><td></td><td colspan=3>"&ors_sl("id_course")&"</td></tr>"
'	ors_sl.movenext
'	loop
'	else
'	response.write "<tr><td></td><td colspan=3>No Course In This Category</td></tr>"
'	end if

''response.write "<td>[<a href=choose_course_form.asp?id_category="&orsall("id_category")&">��������Ԫ�</a>]</td></tr>"

ors_a.movenext
loop

else
response.write "No Course"
end if

'response.write "<tr><td colspan=4><textarea name=detail_studyplan cols=60 rows = 4></textarea></td></tr>"
'response.write ">
'orsall.movenext
'loop
conn.close

'else
'response.write "No Curriculum"
'end if
%>
        <tr> 
          <td> </td>
        </tr></tr>
      </table>
    </div></td>
   <%'	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: choose_category_sp.asp.bak