File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>Message to Student by Dr.dusadee</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

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

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0">
  <tr> 
    <td colspan="2"><div align="right"><img src="../Image/info4stu.gif"></div></td>
  </tr>
  <tr> 
    <td colspan="2" background="../Image/bggreen.gif"><div align="right"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><strong><a href="index.asp">HOME</a> | 
        <a href="http://www.swu.ac.th">SWU</a> | <a href="http://bsri.swu.ac.th">BSRI</a> 
    |</strong></font></div></td>
  </tr>
  <tr> 
    <td width="19%" align="left" valign="top" bgcolor="#CCFF99"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td><strong>Message to..</strong></td>
        </tr>
        <tr> 
          <td height="14" bgcolor="#CCFFCC"><img src="../Image/facebook_logo.gif" width="15" height="15"><a href="http://www.facebook.com/profile.php?id=100001056211628">Dr.Dusadee 
            Y.</a></td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><img src="../Image/facebook_logo.gif" width="15" height="15">Dr.Kanu 
            Priya Mohan</td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><img src="../Image/facebook_logo.gif" width="15" height="15"><a href="http://www.facebook.com/profile.php?id=582371142">Dr.Narisara 
            P.</a></td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><img src="../Image/facebook_logo.gif" width="15" height="15"><a href="http://www.facebook.com/profile.php?id=120785687960475">BSRI</a></td>
        </tr>
        <tr> 
          <td><strong>Student</strong></td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><a href="http://bsris.swu.ac.th/info4stu/detail_stu.asp?group=652124">Generation 
            6</a></td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><a href="http://bsris.swu.ac.th/info4stu/detail_stu.asp?group=550124">Generation 
            5</a></td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><a href="http://bsris.swu.ac.th/info4stu/detail_stu.asp?group=448124">Generation 
            4</a></td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><a href="http://bsris.swu.ac.th/info4stu/detail_stu.asp?group=347124">Generation 
            3</a></td>
        </tr>
        <tr> 
          <td bgcolor="#CCFFCC"><a href="http://bsris.swu.ac.th/info4stu/detail_stu.asp?group=246124">Generation 
            2</a></td>
        </tr>
        <tr>
          <td bgcolor="#CCFFCC"><a href="http://bsris.swu.ac.th/info4stu/detail_stu.asp?group=145124">Generation 
            1</a></td>
        </tr>
      </table></td>
    <td width="81%" align="left" valign="top">
     
      <p>��ª��͹��Ե����</p>
<table width="100%" border="0" cellspacing="0">
    <table>   
<%
id_stugroup=request("group")
	sql_group="select * from student_group where id_stugroup='"&id_stugroup&"' order by id_curriculum"
	set ors_group=server.createobject("adodb.recordset")
	ors_group.open sql_group,conn,1,3
	if not ors_group.eof then
	id_stugroup1=ors_group("id_stugroup")

%>	
<tr>
<td width="892" align="left" valign="top" colspan=4>
	<div align="center"><font size=2><strong> 
      ��ª��͹��Ե������<br>
      <br> 
        <%
	'id_stugroup=request("id_stugroup")
	sql_group="select * from student_group where id_stugroup='"&id_stugroup&"' order by id_curriculum"
	set ors_group=server.createobject("adodb.recordset")
	ors_group.open sql_group,conn,1,3
	if not ors_group.eof then
	ors_group.movefirst
	do while not ors_group.eof

%>
        <tr>
          <td><strong>��ѡ�ٵ� 
          <%
	'response.write ors_group("id_curriculum")
	id_curriculum=ors_group("id_curriculum")
	'response.write id_curriculum
		sql_curri="select * from curriculum where id_curriculum='"&id_curriculum&"'"
		set ors_curri=server.createobject("adodb.recordset")
		ors_curri.open sql_curri,conn,1,3
		response.write  ors_curri("curriculum_full")&"</td>"
	%>
          <td><strong>Ẻ 
            <%
	id_type_curriculum=ors_group("id_type_curri")
	set ors_tc=server.createobject("adodb.recordset")
	 sqlmark_tc="select * from type_curriculum where id_type_curri='"&id_type_curriculum&"'"
	 ors_tc.open sqlmark_tc,Conn,1,3
		response.write ors_tc("type_curri_th")
	%> </td>
          <td><strong>��蹷�� 
            <%
	response.write ors_group("no_stugroup")
	%> </td></div>
          <td ><strong>�Ң� 
            <%
	id_major=ors_group("id_major")
	set ors5=server.createobject("adodb.recordset")
	 sql5="select * from major where id_major='"&id_major&"'"
	 ors5.open sql5,Conn,1,3
	ors5.movefirst
		response.write ors5("major_th")
	%> </td>
          <td ><strong></td>
        </tr>
        <%
		response.write "<tr><td colspan=3>�������"&ors_group("id_stugroup")
		
		response.write "</td></tr>"
	id_stugroup=ors_group("id_stugroup")
	sqlall="select * from student where id_stugroup='"&id_stugroup&"' "
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
		if not orsall.eof then
		i=1
		orsall.movefirst
		do while not orsall.eof
		id_status=orsall("id_status_edu")
		ii=i mod 2
 if ii=0 then
					 bgc="#EBFFD7"
					 else
					 bgc="#ffffff"
					 end if
		'ʶҹТͧ���Ե
				 set ors3=server.createobject("adodb.recordset")
	 sql3="select * from status_edu where id_status_edu='"&orsall("id_status_edu")&"'"
		'sql3="select * from status_edu where id_stu='"&orsall("id_stu")&"' and id_status_edu='1' or id_status_edu='2'"
	 ors3.open sql3,Conn,1,3
			
			if not ors3.eof then
			
			if id_status=1  then
		response.write "<tr bgcolor='"&bgc&"'><td>"&orsall("id_stu")&"</td><td>"&orsall("name_stu")&"  "&orsall("sur_stu")&"</td><td>"&orsall("id_status_edu")&"</td>"
		response.write "<td>"
		response.write orsall("tell_mobile")&","&orsall("tell_home")&","&orsall("email_stu")
		elseif id_status=2 then
		response.write "<tr bgcolor='"&bgc&"'><td>"&orsall("id_stu")&"</td><td>"&orsall("name_stu")&"  "&orsall("sur_stu")&"</td><td>"&orsall("id_status_edu")&"</td>"
		response.write "<td>"
		response.write orsall("tell_mobile")&","&orsall("tell_home")&","&orsall("email_stu")
end if
		
		end if
		i=i+1
		orsall.movenext
		loop
		else
		response.write "<tr><td>No Student</td></tr>"
		end if
		ors_group.movenext
		loop
		end if
		end if
	%>
      </table>
      <p></p>
      
      </td>
  </tr>
  <tr> 
    <td colspan="2" background="../Image/bggreen.gif">&nbsp;</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: info4stu/detail_stu.asp.bak