MySQL Insert Help

I am trying to insert data into my MySQL database nothing is happening. I can do a select fine and when I do my insert it returns a cursor.rowcount of 1, but when I look in the database I don't see my entry.

One thing I notice is that I'm using %s for the values while some of the variables are integers, some are strings, and some are floats. I tried to use %d and %f for my ints and floats, but it balked at me.