帮忙看看那里错了.
chjin 2008-06-08 11:00:14 已知数据库都是正确的
<!--#include file="conn.asp"-->
<%
if request.servervariables("content_length")<>0 then
iname=request.form("fname")
ipwd=request.form("fpwd")
sql="select * from everuser where uid='"&iname&"' and upwd='"&ipwd&"'"
set rs=conn.execute(sql)
if rs.eof and rs.bof then
response.write("<script>alert('密码错误');</script>")
else
csql="select * from currentuser where uid='"&iname&"'"
set currentrs=conn.execute(csql)
if not currentrs.bof and not currentrs.eof then
serialnum=currentrs("serialnum")
sql="update currentuser set lastlogin='"&now()&"',ipaddress='"&request("remote_addr")&"' where uid='"&iname&"'"
response.write(sql)
set rs=conn.execute(sql)
end if
response.write("<script>alert('登录成功');location.href='ins.asp?serialnum="&serialnum&"';</script>")
end if
end if
%>
<form action="" method="post" name="f1" onsubmit="return check();">
<table align="center" width="300" border="0">
<tr><th colspan=2>用户登录</th></tr>
<tr><td width="80">用户名:</td><td><input type="text" name="fname" size=20></td></tr>
<tr><td width="80">密 码:</td><td><input type="password" name="fpwd" size=21></td></tr>
<tr><td colspan=2 align="center"><input type="submit" name="fb1" value="确定"> <input type="reset" name="fb2" value="重填"> <input type="button" value="注册" onclick="location.href='register.asp';"></td></tr>
</table>
</form>
<script>
function check()
{
if(document.f1.fname.value==""||document.f1.fpwd.value=="")
{
alert("请认真填写!");
return false;
}
else
{
return true;
}
}
</script>