<!--#include file="../inc/admin.inc"-->
<%if request("isaudit")="ok" then
sql="update company set index=1"' where id=" & cstr(request("id"))
conn.execute sql
end if%><% if request("isaudit")="cancel" then
sql="update company set index=0"' where id=" & cstr(request("id"))
conn.execute sql
end if%>
<%if rs("index")=1 then %> <a href="mcompany.asp?id=<%=rs("id")%>&isaudit=cancel">
取消审核</a>&nbsp
<% else %>
<a href="mcompany.asp?id=<%=rs("id")%>&isaudit=ok">
通过审核</a>&nbsp
<%end if%>

一审核整个表内的全被审核了.郁闷.

sql="update company set index=1"' where id=" & cstr(request("id"))
改成
sql="update company set index=1 where id=" & cstr(request("id"))

中间还加那两个引号干什么

谢谢.的确如此,谢谢啦