<% voteid=request("voteid") id=request("id") if request("id")="" then response.write"" end if set rs=server.CreateObject("adodb.recordset") sql="select * from votechoice where id="&id&"" rs.open sql,conn,1,3 num=rs("num") num=num+1 countadd="update votechoice set num='"&num&"' where id='"&id&"'" conn.execute(countadd) response.write"" 'response.Redirect("show.asp?voteid="&voteid&"") rs.close set rs=nothing conn.close set conn = nothing %>