File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>��䢢������Ҩ�������֡�� </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874"></HEAD>

<tr> 
              <td><div align="right">���͡��������Ե---></div></td>
              <td>
<% 
			  set ors4=server.createobject("adodb.recordset")
	 sqls="select * from student_group where id_stugroup='"&id_stugroup&"'"
	set orss=server.createobject("adodb.recordset")
	orss.open sqls,conn,1,3
	if not orss.eof then

sqlc="select * from curriculum where id_curriculum='"&orss("id_curriculum")&"'"
	set orsc=server.createobject("adodb.recordset")
	orsc.open sqlc,conn,1,3
	if not orsc.eof then
           sqlt="select * from type_curriculum where id_type_curri='"&orss("id_type_curri")&"'"
		   set orst=server.createobject("adodb.recordset")
		   orst.open sqlt,conn,1,3
		   if not orst.eof then
	response.write orsc("curriculum_sum")&" "&orst("type_curri_th")&" ��� "&orss("no_stugroup")&"</td>"				
		   end if
end if
end if
		
		%>
		
			  
            </tr>
		<tr> 
              <td><div align="right">�ա���֡��</div></td>
              <td>
			  <select name="id_year">
<% 
mydate=date
myyear=year(mydate)

yearbegin=myyear+532
'myyear=myyear+543
myyear=id_year
'response.write "<tr><td>aaa"&yearbegin&""&myyear&"bbb</td></tr>"
i=0

do while i<15
	%>
		<option <%
		if yearbegin=cint(myyear) then 	%>
		value=
		<%=myyear%>
		selected
		<%else%>
		value=
		<%=yearbegin%>
		<%end if%>>
		<%=yearbegin%><%'=myyear%>
		</option>
		<%i=i+1
	yearbegin=yearbegin+1
		loop
		%>
			  </select>
			  <%
			  sql_lec="select * from lecturer"
			set ors_lec=server.createobject("adodb.recordset")
			ors_lec.open sql_lec,conn,1,3
			      if not ors_lec.eof then
				  response.write "<tr><td><div align=right>���͡�Ҩ�������͹<td><select name=id_lecturer>"
				  ors_lec.movefirst
				  do while  not ors_lec.eof
				  %>
				  <option <%if id_lecturer=ors_lec("id_lecturer") then %>
				  value=<%=id_lecturer%> selected
				  <%else%>
				  value=<%=ors_lec("id_lecturer")%>
				  <%end if%>>
				  <%=ors_lec("name_lec")&"    "&ors_lec("sur_lec")%></option>
				  <%
				  ors_lec.movenext
				  loop
				  response.write "</select></td></tr>"
				  else
				  response.write "<tr><td>No Lecturer</td></tr>"
				  end if
			  %>
	  
            </tr>
           
            <tr>
              <td>&nbsp;</td>
              <td><input type="submit" name="Submit" value="���" >
                </td>
            </tr>
          </table>
      </form>
      </div></td>
    <td width="143" align="left" valign="top" background="menu_6.gif">
    </td>
  </tr>
  <tr > 
    <td colspan="3" background="bghead1.gif">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="3"></td>
  </tr>
  <tr> 
    <td><font color="#FF3300">&nbsp;</font></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</BODY>
</HTML>

File Manager

Editing: edit_advisor_form.aspll