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

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

<table width="100%" border="0" cellspacing="0">
  <tr> 
    <td> </td>
  </tr>
  <tr> 
    <td width="892" align="left" valign="top"><div align="center"><font size=2><strong>
	<%if session("tb_edit") = 2 then%>
	[<a href=add_course_form.asp>+��������������Ԫ�+</a>] 
        [<a href=index_course.asp>�ʴ�����������Ԫҷ�����</a>]
		<%end if%><br>
        �Ѵ��Ǵ����Ԫ�<br>
        <br>
        <table border=0>
          <%	
id_category=request("id_category")
sql="select * from category_course where id_category='"&id_category&"'"
set ors=server.createobject("adodb.recordset")
ors.open sql,conn,1,3
if not ors.eof then
response.write "<tr><td colspan=4 align=center><strong>"&ors("category_group")&""&ors("category_group_name")&""&ors("category")&""&ors("id_category")&"</td></tr>"
'response.write "<tr><td></td></tr>"
sql_t="select * from course_category where id_category='"&id_category&"'"
set ors_t=server.createobject("adodb.recordset")
ors_t.open sql_t,conn,1,3
if not ors_t.eof then
ors_t.movefirst
do while not ors_t.eof

'response.write"<td ></td>"
      sql_c="select * from course where id_course ='"&ors_t("id_course")&"'"
	  set ors_c=server.createobject("adodb.recordset")
	  ors_c.open sql_c,conn,1,3
response.write "<tr><td>"&ors_c("id_course_th")&"   ("&ors_t("id_course")&")</td>"
response.write "<td >"&ors_c("course_th")&"</td>"
response.write "<td >"&ors_c("credit")&"</td>"
response.write "<td>[       <a href=del_choose_course.asp?id_course="&ors_t("id_course")&"&id_category="&id_category&">ź</a>        ]</td>"
response.write "</tr>"

ors_t.movenext
loop
else
response.write "<tr><td colspan=4>No course!!!!</td></tr>"
end if
response.write "<tr><td colspan=4 align=center><strong><br>��س����͡����Ԫ�<br></td></tr>"

sql_all="select * from course"
		set ors_all=server.createobject("adodb.recordset")
		ors_all.open sql_all,conn,1,3
if not ors_all.eof then
ors_all.movefirst
do while not ors_all.eof
		sql_a="select * from course_category where id_course='"&ors_all("id_course")&"' "
		set ors_a=server.createobject("adodb.recordset")
		ors_a.open sql_a,conn,1,3
					if  ors_a.eof then
												response.write "<tr><td>"&ors_all("id_course_th")&"   ("&ors_all("id_course")&")</td>"
												response.write "<td >"&ors_all("course_th")&"</td>"
												response.write "<td >"&ors_all("credit")&"</td><td >[<a href=choose_course.asp?id_course="&ors_all("id_course")&"&id_category="&id_category&">���͡</a>]</td></tr>"
					'else
					'response.write "<tr><td colspan=4>No course"&id_course&"</td></tr>"
				end if
		ors_all.movenext
		loop
		else
		response.write "No Match"
		end if

end if	%>
       
      </div></td>
  </tr> </table>
  <%	else '���Է�
	response.write "<tr><td colspan=3><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: choose_course_form.asp.bak