For loop with sqlite always inserting first value
<p>I am making a voting application and it allows the user to type all candidates with commas between each and hit enter to create a vote with those candidates.</p>

<pre><code>def newVote(event):
                pos = position.get()
                candidates = addCandEntry.get()
                formatted = [x.strip() for x in candidates.split(',')]
                for x in formatted:
                    c.execute("INSERT INTO current VALUES(?, ?, ?)", (pos,x,0,))
                    c.execute('SELECT * FROM current WHERE position="Chief"')
                    print(c.fetchone())
</code></pre>

<p>If I were to pass the following values into the tkinter entry for position <code>dad,mom,son,sister,grandma</code> It would give this output in the sql</p>

<pre><code>('Chief', 'dad', 0)
('Chief', 'dad', 0)
('Chief', 'dad', 0)
('Chief', 'dad', 0)
('Chief', 'dad', 0)
</code></pre>

<p>How can I make it add each value instead of just the first one?</p>

<p>Here is the full code if you need it</p>

<pre><code>import tkinter
from tkinter import *
import sqlite3
import datetime


# testing purposes only
password = 'test'

# create database file
conn = sqlite3.connect('firefight')
c = conn.cursor()

# create tables
c.execute('''CREATE TABLE IF NOT EXISTS users(
          username text, password text, admin boolean)''')
c.execute('''CREATE TABLE IF NOT EXISTS positions(
          position text)''')
c.execute('''CREATE TABLE IF NOT EXISTS current(
          position text, candidate text, votes int)''')
c.execute('''CREATE TABLE IF NOT EXISTS past(
          date DATE, position text, candidate text, votes int, winner boolean)''')

c.execute("INSERT INTO users VALUES('admin', 'VoteProgram', 'yes')")


'''
tables:
users:
    username text
    password text
    admin boolean
positions:
    position text
current:
    position text
    candidate text
    votes int
past:
    position text
    candidate text
    votes int
    winner boolean
'''

# define root window
root = tkinter.Tk()
root.minsize(width=800, height = 600)
root.maxsize(width=800, height = 600)

# Admin sign in Label
areAdmin = Label(root, text="Administrator sign in", font=("Arial", 18))
areAdmin.pack()

# password label and password
passwordLabel = Label(root, text="Password: ", font=("Arial", 12))
passwordLabel.place(x=300, y=30)

# password entry
adminPasswordEntry = Entry(root)
adminPasswordEntry.place(x=385, y=32.5)

# function for button
def getEnteredPassword(event):
    enteredPassword = adminPasswordEntry.get()
    if enteredPassword == password:
        # define admin window
        admin = tkinter.Toplevel()
        admin.minsize(width=800, height = 600)
        admin.maxsize(width=800, height = 600)
        # label saying to change password
        changePasswordLabel = Label(admin, text="It is recommended to change your password the first time you log in.",
                                    font=("Arial", 16), wraplength=500)
        changePasswordLabel.pack()
        # old password
        changePassword_OldPasswordLabel = Label(admin, text="Old Password: ", font=("Arial", 12))
        changePassword_OldPasswordLabel.place(x=250, y=50)
        changePassword_OldPassword = Entry(admin)
        changePassword_OldPassword.place(x=365, y=52.5)
        # new password
        changePassword_NewPasswordLabel = Label(admin, text="New Password: ", font=("Arial", 12))
        changePassword_NewPasswordLabel.place(x=250, y=70)
        changePassword_NewPassword = Entry(admin)
        changePassword_NewPassword.place(x=365, y=72.5)

        # function to change password
        def passwordChangeCommand(event):
            global password
            oldPasswordValue = changePassword_OldPassword.get()
            newPasswordValue = changePassword_NewPassword.get()
            if oldPasswordValue == password:
                password = newPasswordValue
            else:
                wrong = tkinter.Toplevel()
                wrong.minsize(width=200, height = 100)
                wrong.maxsize(width=200, height = 100)
                Label(wrong, text="Sorry that password is incorrect!", font=("Arial", 24), anchor=W, wraplength=180,
                      fg="red").pack()

        # submit button
        newPasswordSubmit = Button(admin, text="Submit", width=10, command=passwordChangeCommand)
        newPasswordSubmit.place(x=350, y=100)

        newVoteLabel = Label(admin, text="Create New Vote", font=("Arial", 16))
        newVoteLabel.place(x=310, y=135)

        # positions drop down
        newVoteChoosePositionLabel = Label(admin, text="Choose the position you are voting for", font=("Arial", 12))
        newVoteChoosePositionLabel.place(x=265, y=170)
        position = StringVar(admin)
        position.set("Chief")
        newVoteOption = OptionMenu(admin, position, "Chief", "First Lieutenant", "Second Lieutenant", "Third Lieutenant",
                                   "Fourth Lieutenant")
        newVoteOption.place(x=355, y=195)

        #add candidates
        addCandLabel = Label(admin, text="Add candidates below, separate each candidate with a comma then press enter when all candidates have been entered"
                             , font=("Arial", 11), wraplength=300, anchor=W)
        addCandLabel.place(x=255, y=235)
        addCandEntry = Entry(admin, width=40)
        addCandEntry.place(x=272, y=295)

        #new vote
        newVoteButton = Button(admin, text="Create Vote", width=15)
        newVoteButton.place(x=335, y=325)

        def newVote(event):
            pos = position.get()
            candidates = addCandEntry.get()
            formatted = [x.strip() for x in candidates.split(',')]
            for x in formatted:
                c.execute("INSERT INTO current VALUES(?, ?, ?)", (pos,x,0,))
                c.execute('SELECT * FROM current WHERE position="Chief"')
                print(c.fetchone())


        addCandEntry.bind("&lt;Return&gt;", newVote)
        newVoteButton.bind("&lt;Button-1&gt;", newVote)

    else:
        wrong = tkinter.Toplevel()
        wrong.minsize(width=200, height=100)
        wrong.maxsize(width=200, height=100)
        Label(wrong, text="Sorry that password is incorrect!", font=("Arial", 24), anchor=W, wraplength=180,
              fg="red").pack()

# enter button for password
passwordEnterButton = Button(root, text="Enter", width=10)
passwordEnterButton.place(x=360, y=60)
passwordEnterButton.bind("&lt;Button-1&gt;", getEnteredPassword)
root.bind("&lt;Return&gt;", getEnteredPassword)

mainloop()
</code></pre>