save.asp

一个不错的拍卖网站,fdsafdsfdfe

<!--#include file="conn.asp" -->
<!-- #include file="inc/adovbs.inc" -->
<!-- #include file="inc/info.asp" -->
<%
response.buffer=true

uname=SQLStr(rst("username"))
pwd=SQLStr(rst("password"))
pwd2=SQLStr(rst("password2"))
e_mail=SQLStr(rst("email"))
'sex=rst("sex")
'year=rst("year")
'month=rst("month")
prov=SQLStr(rst("TPL_prov"))
city=SQLStr(rst("TPL_city"))

if pwd=pwd2 and pwd<>"" and uname<>"" and email<>"" then
sql2="select regusername from users where regusername='"&uname&"'"
set rs=conn.execute(sql2)
	if not rs.eof then
	response.write "用户名已经存在,请选择另外用户名"
	response.end
	else
	sql="insert into users(regadmin,regUsername,regPassword,regEmail,regState,regCity, regtime )values('N','"&uname&"','"&pwd&"','"&e_mail&"','"&prov&"','"&city&"','"&now&"')"
	conn.execute(sql)
	response.write"<SCRIPT language=JavaScript>alert('恭喜您!成为"&WebName&"的会员,请登录！');"
	response.write"this.location.href='login.asp';</SCRIPT>"
	end if
end if

%>
</body>
</html>