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">
</title>
 <%	
	session("tb_name")="student"%>

<%
if  session("tb_edit")=2 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

id_stugroup=request.form("id_stugroup")
	id_stu=request.form("id_stu")
	comments=request.form("comments")

sqlall="select * from student_comment "
		set orsall=server.createobject("adodb.recordset")
		orsall.open sqlall,conn,1,3
if not orsall.eof then 
			orsall.movelast
			id_comment=orsall("id_comment")+1
			else
			id_comment=1
     end if
	 datetimeadd=now
	 sql_add="insert into student_comment(id_student,id_comment,comment,datetimeadd,id_status) values ('"&id_stu&"',"&id_comment&",'"&comments&"','"&datetimeadd&"','1')"
	 set ors_add=server.createobject("adodb.recordset")
	 ors_add.open sql_add,conn,1,3
		response.write "<meta http-equiv='refresh' content ='0;url=add_comment_stu_form.asp?id_stu="&id_stu&"&id_stugroup="&id_stugroup&"'>"
  %>

<%
 else '���Է�
	response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է�
	end if '���Է�
%>

File Manager

Editing: add_comment_stu.asp.bak