title: Listing table results to HTML with Flask
body: <p>I am struggling with passing my SELECT all statement results to my view. I am using flask and MySQLdb. What is the proper syntax to display all my results from my table to my HTML page? I would love to pass a list through, but was unable to figure the syntax out for that.</p>
  
  <p>HTML call <code>{{ session.qid }}</code> just to test, and nothing displayed.</p>
  
  <p><strong>Here's the python code I have so far:</strong></p>
  
  <pre><code>@app.route('/view_answered/', methods=['GET','POST'])
  def view_answered():
      error = ''
      try:
          if request.method == 'POST':
              c, conn = connection()
              clientcid = session['clientcid']
  
              cursor.execute("SELECT * FROM tickets WHERE cid = 1 AND solved = 0")
              results = cursor.fetchall()
              x = 0
              qid = []
              difficulty = []
              time_stamp = []
              title = []
              body = []
  
              for row in results:
                  qid[x] = row[0]
                  difficulty[x] = row[3]
                  time_stamp[x] = row[4]
                  title[x] = row[6]
                  body[x] = row[7]
  
                  x = x + 1
  
              conn.commit()
              c.close()
              conn.close()
              gc.collect()
              session['qid'] = qid
              session['difficulty'] = difficulty
              session['time_stamp'] = time_stamp
              session['title'] = title
              session['body'] = body
              return redirect(url_for('view_answered'))
  
          else:
              error = "Something is aloof."
  
          return render_template("view_answered.html")
  
      except Exception as e:
          return(str(e))
  </code></pre>