kun én post i db

Hej

Jeg har et lille problem med nedenstående kode. Jeg har oprettet en afstemning, men den gemmer kun den allerførste post. Også selvom det er en anden computer der stemmes fra. Hvor opstår fejlen??


<%
    vote_input = request.form("input")
    user_ip = request.serverVariables("REMOTE_ADRR")
   
    IF vote_input = "" THEN
%>

<form name="form1" method="post" action="<% request.ServerVariables("SCRIPT_NAME") %>">
   
    <table>
        <TR>
            <TD> <input class="blank" name="input" type="radio" value="vote_1"> </TD>
            <TD> <p class="lilleTxt">Opfordring fra ansøgning</p></TD>
        </TR>
        <TR>
            <TD> <input class="blank" name="input" type="radio" value="vote_2"> </TD>
            <TD> <p class="lilleTxt">Firma</p></TD>
        </TR>
        <TR>
            <TD> <input class="blank" name="input" type="radio" value="vote_3"> </TD>
            <TD> <p class="lilleTxt">Venner/Familie</p></TD>
        </TR>
        </table>
        <table>
            <TR>
                <TD>
                    <input class="lilleTxt" name="send" type="submit" value="Send" >
                </TD>
            </TR>
        </table>
</form>

<% else %>

    <%
        sql = "SELECT Ip FROM Vote WHERE Ip ='" & user_ip & "'"
        Set rs = conn.Execute(sql)
       
        if rs.eof  THEN
            been_here_before = "NO"
        end if
       
        if been_here_before = "NO" THEN
            sql = "INSERT INTO Vote(Ip, " & vote_input & ") VALUES ('" & user_ip & "', 1)"
            Set rs = conn.Execute(sql)
           
        end if
    %>
   
   
    <%
               
        sql = "SELECT COUNT(*) AS total_1 FROM Vote WHERE vote_1=1;"
        set rs = conn.Execute(sql)
        sql1 = "SELECT COUNT(*) AS total_2 FROM Vote WHERE vote_2=1;"
        set rs1 = conn.Execute(sql1)
        sql2 = "SELECT COUNT(*) AS total_3 FROM Vote WHERE vote_3=1;"
        set rs2 = conn.Execute(sql2)
        sql3 = "SELECT COUNT(*) AS total_votes FROM Vote;"
        set rs3 = conn.Execute(sql3)
       
        total1 = rs ("total_1")
        total2 = rs1 ("total_2")
        total3 = rs2 ("total_3")
        all = rs3 ("total_votes")
       
    %>
   
   
        <p class="lilleTxt">Opfordring fra ansøgning <%= round((total1/all)*100) %> %<BR>
            Firma <%= round((total2/all)*100) %> %<BR>
            Venner/Familie <%= round((total3/all)*100) %> %<BR>
            Antal stemmer <%= all %></p>
   
   
    <% if been_here_before <> "NO" THEN %>
   
    <% else %>
   
    <% end if %>
    <% conn.close %>
<% end if %>