<%@ Language=VBScript %>
<%
'wrong login ...?
if session("login") <> "yes" then
Response.Redirect ("adminlog.asp")
end if
%>
<%
'create connection
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("/fpdb/engglas.mdb")
'query to select active data...
sql = "SELECT * FROM title"
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
c = 0
for g = 1 to rs.RecordCount
c = g
rs.MoveNext
if rs.EOF then
rs.MoveLast
end if
next
%>
Update new
<%
'update title
rs.addnew
rs.Fields("title") = Request.Form("title")
rs.fields("id") = int(c) + 1
rs.fields("active") = "n"
rs.Update
d = rs.fields("id")
%>
<%
rs.close
set rs = nothing
sql = "SELECT * FROM vote"
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
%>
<%
'10 textboxses on previous page ... go from 1 to 10
for b = 1 to 10
if Request.form(int(b)+1) = "" then
'response.redirect("admintit.asp")
else
rs.addnew
rs.fields("answer") = Request.form(int(b)+1)
rs.fields("id") = d
rs.fields("pic") = int(b)
rs.update
end if
rs.movenext
if rs.eof then
rs.movelast
end if
next
%>