title: Python to MySQLdb will not pass variables I think I have tried everything
body: <p>I am trying to store some TV information in a MySQLdb. I have tried about everything and I cannot get the variables to post. There is information in the variables as I am able to print the information. </p>
  
  <p>My Code:</p>
  
  <pre><code>import pytvmaze
  import MySQLdb
  
  AddShow = pytvmaze.get_show(show_name='dexter')
  MazeID = AddShow.maze_id
  ShowName = "Show" + str(MazeID)
  
  
  show = pytvmaze.get_show(MazeID, embed='episodes')
  db = MySQLdb.connect("localhost","root","XXXXXXX","TVshows" )
  cursor = db.cursor()
  
  for episode in show.episodes:
     Show = show.name
     ShowStatus = show.status
     ShowSummary = show.summary
     Updated = show.updated
     Season = episode.season_number
     Episode = episode.episode_number
     Title = episode.title
     AirDate = episode.airdate
     ShowUpdate = show.updated
     EpisodeSummary = episode.summary
     try:
        sql =  "INSERT INTO " + ShowName  +  " VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)""" (Show,ShowStatus,ShowSummary,Updated,Season,Episode,Title,AirDate,ShowUpdate,EpisodeSummary)
        cursor.execute(sql)
        db.commit()
     except:     
        db.rollback()
  db.close()
  </code></pre>
  
  <p>Any thoughts? Thanks in advance.</p>
  
  <p><strong>EDIT - WORKING CODE</strong> </p>
  
  <pre><code>import pytvmaze
  import MySQLdb
  
  AddShow = pytvmaze.get_show(show_name='dexter')
  MazeID = AddShow.maze_id
  ShowNameandID = "Show" + str(MazeID)
  
  show = pytvmaze.get_show(MazeID, embed='episodes')
  db = MySQLdb.connect("localhost","root","letmein","TVshows" )
  cursor = db.cursor()
  
  for episode in show.episodes:
     ShowName = show.name
     ShowStatus = show.status
     ShowSummary = show.summary
     Updated = show.updated
     Season = episode.season_number
     Episode = episode.episode_number
     Title = episode.title
     AirDate = episode.airdate
     ShowUpdate = show.updated
     EpisodeSummary = episode.summary    
     sql = "INSERT INTO " + ShowNameandID  +  """ VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"""
     cursor.execute(sql, (ShowName, ShowStatus, ShowSummary, Updated, Season, Episode, Title, AirDate, ShowUpdate, EpisodeSummary))
     db.commit()
     print sql ##Great for debugging
  db.close()
  </code></pre>