<%
set rsb=server.createobject("adodb.recordset")
conn="dbq="+server.mappath("QQ173573275.mdb")+";driver={microsoft access driver (*.mdb)};pwd=qq173573275"
sql="select name from onlinesignQQ173573275"
rsb.open sql,conn,1,3
if request.servervariables("REQUEST_METHOD")="POST" then
name=request.form("name")
city=request.form("city")
Educaton=request.form("Educaton")
addre=request.form("addre")
code=request.form("code")
mail=request.form("mail")
phone=request.form("phone")
phome=request.form("phome")
content=request.form("content")
aim=request.form("aim")
date123=request.form("date123")
if name="" then
response.write ""
response.end
end if
if addre="" then
response.write ""
response.end
end if
if phone="" then
response.write ""
response.end
end if
set rs=server.createobject("adodb.recordset")
conn="dbq="+server.mappath("QQ173573275.mdb")+";driver={microsoft access driver (*.mdb)};pwd=qq173573275"
sql="insert into onlinesignQQ173573275(name,city,Education,addr,code,mail,phone,aim,phome,content,date123) values "
sql=sql&"('"&name&"','"&city&"','"&aim&"','"&code&"','"&mail&"','"&phone&"','"&Educaton&"','"&addre&"','"&phome&"','"&content&"','"&date123&"')"
rs.open sql,conn,1,3
set rs=nothing
response.write ""
end if
%>
