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="style.css" rel="stylesheet" type="text/css">

<link href="Templates/style.css" rel="stylesheet" type="text/css">

</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr bgcolor="#9900FF"> 
    <td width="15%" ><img src="culture/logo1.gif" width="97" height="97" border="0"></td>
    <td><div align="right"> 
        <h5><font color="#FFFFFF">�ҹ�ӹغ��ا��Ż�Ѳ�����<br>
          ʶҺѹ�Ԩ�¾ĵԡ�����ʵ�� ����Է�������չ��Թ�����ò</font></h5>
      </div></td>
  </tr>
  <tr> 
    <td bgcolor="#9999FF">�է�����ҳ</td>
    <td><div align="right">[<a href="index_culture.asp">˹���á</a>][<a href="http://www.swu.ac.th/">SWU</a>][<a href="http://bsri.swu.ac.th">BSRI</a>]</div></td>
  </tr>
  <tr> 
    <td align="left" valign="top" bgcolor="#9999FF"><%
	sqly="select * from culture_year order by id_year desc"
	set orsy=server.createobject("adodb.recordset")
			orsy.open sqly,conn,1,3
			if not orsy.eof then
			orsy.movefirst
					do while not orsy.eof
					response.write "<a href=culture_dyear.asp?idy="&orsy("id_year")&">"&orsy("id_year")&"</a><br>"
					orsy.movenext
					loop
			end if
	
	%> 
    </td>
    <td align="center" valign="top">
<%
idyear=request("idy")

%>
<table width="100%" border="0" cellspacing="0">
  <tr> 
    <td colspan="3"> </td>
  </tr>
  <tr>

<%'sqlall="select * from culture_detail where statusdel='1' order by name_lec"
		sqlall="select * from culture_detail where id_year='"&idyear&"' order by id_m asc"
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof then
		orsall.movefirst
		countcolum=0
		do while not orsall.eof
		countcolum=countcolum+1
		ii=countcolum mod 2
					 if ii=0 then
					 bgc="#EBFFD7"
					 else
					 bgc="#ffffff"
					 end if
		mon=orsall("id_m")
		if  mon="1" then
				mont="���Ҥ�"
			elseif mon="2" then
				mont="����Ҿѹ��"
			elseif mon="3" then
				mont="�չҤ�"
			elseif mon="4" then
				mont="����¹"
			elseif mon="5" then
				mont="����Ҥ�"
			elseif mon="6" then
				mont="�Զع�¹"
			elseif mon="7" then
				mont="�á�Ҥ�"
			elseif mon="8" then
				mont="�ԧ�Ҥ�"
			elseif mon="9" then
				mont="�ѹ��¹"
			elseif mon="10" then
				mont="���Ҥ�"
			elseif mon="11" then
				mont="��Ȩԡ�¹"
			elseif mon="12" then
				mont="�ѹ�Ҥ�"
			end if
		response.write "<tr bgcolor="&bgc&">"'<td>"&orsall("id_project")&"</td>"
		response.write "<td>"&mont&"</td><td>"&orsall("project_n")&"</td><td>[<a href=culture/file/"&orsall("file_n")&">"&orsall("file_n")&"</a>]</td><td>[<a href=culture_dpic.asp?id_project="&orsall("id_project")&">Local</a>]"
		if orsall("picture_link")=0 then
		else
	response.write 	"[<a href="&orsall("picture_link")&" target=_blank>Link</a>]"
	end if		
	response.write "</tr>"
	
		orsall.movenext
		loop
		else
		response.write "<tr><td colspan=5>No project</td></tr>"
		end if
	%>
      </table></div>

</td>
  </tr>
  <tr bgcolor="#9900FF">
    <td align="left" valign="top"></td>
    <td>&nbsp;</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: culture_dyear.asp.bak