请大神帮助下小弟！谢谢 - ASP技术论坛

楼主

已结贴√ 问题点数：20 回复次数：1

请大神帮助下小弟！谢谢

麻烦大神看下这里那里出错了！每次注册都是显示“对不起，此用户名已经有人使用！请换一个吧”
都是说被使用过的！

不知道是哪里出错了  大神帮忙下！谢谢！！

<%@ LANGUAGE = VBScript %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用户注册</title>
</head>



<body>
<%
    username = formdata(request.form("username"))
    if username="" then
    %>
    <script language='javascript'> alert ('用户名不能为空！');history.go(-1)</script>
    <%
   else
       sSql="select id from users where username='"& username &"'"
      set rs = conn.execute(sSql)

     if not rs.eof then
    %>
    <script language='javascript'> alert ('对不起，此用户名已经有人使用！请换一个吧！');history.go(-1)</script>
    <%
    response.End()
      else
    userpass = md5(trim(formdata(request.form("userpwd"))),16)
    uname = formdata(request.form("truename"))
    qq = formdata(request.form("oicq"))
    province = formdata(request.form("shf"))
    city = formdata(request.form("chs"))
    bank_bank = formdata(request.form("carofbank"))
    bank_name = formdata(request.form("bankname"))
    bank_num = formdata(request.form("carnumber"))
    regfrom = formdata(request.form("regfrom"))
    if regfrom="" then
    regfrom="&admin&"
    else
SQL = "Select regfrom From users  where username='"&regfrom&"'"
set rr=conn.execute(sql)
regf=rr("regfrom")
    regfrom="&"&regfrom&"&"&regf
    end if
    'response.write regfrom

    SQL = "Select * From users"
    Set Rs = Server.CreateObject("ADODB.Recordset")
    Rs.Open SQL,conn,1,2

    Rs.addnew
    Rs("username") = username
    Rs("userpass") = userpass
    Rs("qq") = qq
    Rs("bank_bank") = bank_bank
    Rs("bank_area")= province&city
    Rs("bank_name") = bank_name
    Rs("bank_num") = bank_num

    Rs("regfrom") = regfrom
    Rs("state") = 0
    Rs("bonus11")=1700
Rs("bonus12")=570
Rs("bonus13")=280
Rs("bonus14")=6.6
Rs("bonus15")=17
Rs("bonus16")=170
Rs("bonus17")=17
Rs("bonus18")=170
Rs("bonus19")=6.8
Rs("bonus21")=1700
Rs("bonus22")=570
Rs("bonus23")=280
Rs("bonus24")=6.6
Rs("bonus25")=17
Rs("bonus26")=170
Rs("bonus27")=17
Rs("bonus28")=170
Rs("bonus31")=1700
Rs("bonus32")=570
Rs("bonus33")=280
Rs("bonus34")=6.6
Rs("bonus35")=17
Rs("bonus36")=170
Rs("bonus37")=17
Rs("bonus38")=170
Rs("bonus41")=1700
Rs("bonus42")=570
Rs("bonus43")=280
Rs("bonus44")=6.6
Rs("bonus45")=17
Rs("bonus46")=170
Rs("bonus47")=17
Rs("bonus48")=170
Rs("bonus51")=1700
Rs("bonus52")=570
Rs("bonus53")=280
Rs("bonus54")=6.6
Rs("bonus55")=17
Rs("bonus56")=170
Rs("bonus57")=17
Rs("bonus58")=170
Rs("bonus59")=6.8
    Rs.update
    closedb()
    'response.write regfrom
%>
<script language='javascript'> alert ('注册成功');location.href='../index.asp'</script>
<%
end if
end if

%>
</body>
</html>

搜索更多相关主题的帖子: file　title　用户名　 include　content　