我想把一个班级添加到数据中，代码如：
<%
if request("class") <> "" and request("class_id") <> "" then
sql="select * from classinfor where class_id='"& request("class_id") & "'"
my_rs.open sql,my_conn,3,3
if my_rs.eof then
my_rs.addnew
my_rs("class")=request("class")
my_rs("remark")=request("remark")
my_rs.update
ok=1
end if
end if
if ok=1 then
%>
<script language="vbscript">
msgbox"添加成功！"
</script>
<%end if%>
<%
if request("del")<>"" then
sql="delete * from administrator where username='"&request("del")&"'"
my_rs.open sql,my_conn,3,3
er=1
end if


if er=1 then
%>
<script language="vbscript">
msgbox"删除成功！"
</script>
<%end if%>

但是结果却添不上
请名位帮个忙解决一下

<%
if request("class") <> "" and request("class_id") <> "" then
sql="select * from classinfor where class_id='"& request("class_id") & "'"
my_rs.open sql,my_conn,1,3
if my_rs.eof and my_rs.bof then
my_rs.addnew
my_rs("class")=request("class")
my_rs("remark")=request("remark")
my_rs.update
ok=1
end if
end if
if ok=1 then
%>
<script language="vbscript">
msgbox"添加成功！"
</script>
<%end if%>
<%
if request("del")<>"" then
sql="delete * from administrator where username='"&request("del")&"'"
my_rs.open sql,my_conn,3,3
er=1
end if


if er=1 then
%>
<script language="vbscript">
msgbox"删除成功！"
</script>
<%end if%>

支持2楼