I have this code in python:

query = "SELECT product_id FROM product_orders WHERE table_number = " e
cursor.execute(query)
records = cursor.fetchall()
for record in records:
    query2 = "SELECT * FROM productss WHERE id = " str(record[0])
    cursor.execute(query2)
    record2 = cursor.fetchall()
    sum=0
    for record1 in record2:
        sum = sum   record1[2]
        tree.insert("", tk.END, values=record1)

tree2.insert("", tk.END, values=sum)

The problem is the sum variable does not make summing, but stores only the last value of record1. Any solution for this?

CodePudding user response：

It looks like you have sum = 0 inside of a for loop. Maybe if you take it out of the loop and make it a list of sums that will fix your issue. Also, as another user has said, sum is a built-in name, you can name your variable s instead.