# Python - List Iteration output problem

The attached code produces an output of individual lists as shown below.
[1002, 2, 36, 4, 5]
[1003, 16, 17, 18, 14, 15]
[1081, 17, 19, 13, 22]
[1090, 4]
[1235, 34, 20, 30]
[120474, 25, 36, 29, 30]
[158846, 24, 27, 37, 30]
[169450, 1]
[272338, 10]
[274240, 5]
[416757, 11]
[436329, 29, 30]
[461640, 30, 3, 29, 14, 7]
[464860, 8, 1, 6, 7]
[491485, 33, 34, 3, 27, 22]
[524052, 10]
[529495, 29]
[590314, 23]
[659018, 24, 33, 27, 35, 30]
[890419, 9, 26, 25, 30, 7]
[980337, 19, 28, 22]
[997638, 1, 3, 6, 15]

My problem is that I need this output to be a single two dimensional list as shown below.  It seems really a straight forward thing to achieve, but I just can't manage it.

[ [1002, 2, 36, 4, 5]
[1003, 16, 17, 18, 14, 15]
[1081, 17, 19, 13, 22]
[1090, 4]
[1235, 34, 20, 30]
[120474, 25, 36, 29, 30]
[158846, 24, 27, 37, 30]
[169450, 1]
[272338, 10]
[274240, 5]
[416757, 11]
[436329, 29, 30]
[461640, 30, 3, 29, 14, 7]
[464860, 8, 1, 6, 7]
[491485, 33, 34, 3, 27, 22]
[524052, 10]
[529495, 29]
[590314, 23]
[659018, 24, 33, 27, 35, 30]
[890419, 9, 26, 25, 30, 7]
[980337, 19, 28, 22]
[997638, 1, 3, 6, 15]]

``````#!C:\Python34\python.exe
import json
import traceback
import cgi,cgitb
import mysql.connector as conn
import collections
import datetime
import shelve
import copy
def htmlTop():
print("""Content-type:text/html\n\n
<!DOCTYPE html>
<html lang="en">

<style>
body {
font-size: 100%; /*to support em text sizing*/
margin-top: 0;

}

#backgrd_repeat_image {
background-image: url(images/background.png);
background-position: left top;
background-repeat: repeat;
}

</style>

<meta charset="UTF-8">
<title> Welcomme</title>

""")

def htmlTail():

print("""    its done</body>
</html>""")

def connectDB():
db=conn.connect(host='localhost' ,user='root' ,passwd='844cheminduplan' ,db='python_office')
cursor = db.cursor()
return db, cursor

def enrollments(db,cursor):
sql = "select memberID,T1ytdlatest,T2ytdlatest,T3ytdlatest  from registrations;"
cursor.execute(sql)
results=cursor.fetchall()
return results

#main program
if __name__== "__main__":
try:
htmlTop()
db, cursor = connectDB()
results = enrollments(db,cursor)
for each in results:
test = eval(each[1]) + eval(each[3]) + eval(each[2])
test = list(set(test))
member = each[0]
test = [member] + test
print(test)

htmlTail()
except:
cgi.print_exception()
``````
Web Development SoftwarePython

Last Comment
jameskane

8/22/2022 - Mon