sql="SELECT * from items where pid="&request("pid")&" and pitem="&request("pitem")
Set rs=conn.Execute(sql)
pitemnum=rs("pitemnum")+1
sql="update items set pitemnum="&pitemnum&" where pid="&request("pid")&" and pitem="&request("pitem")
conn.Execute(sql)
sql_1="SELECT * from admin where username='"&session("admin")&"'"
Set rs_1=conn.Execute(sql_1)
bb=rs_1("bb")+1
sql_1="update admin set bb='bb' where username='"&session("admin")&"'"
conn.execute(sql_1)