Hi; I have the following code: for row in data: i += 1 total = 0 quantity = form.getfirst('order_' + str(i), '') if quantity != '': sql = 'select * from products p join %s c on p.ID=c.ID where c.ID=%s;' % (client, str(i)) cursor.execute(sql) stuff = cursor.fetchone() price = str(int(stuff[5]*100)) price = price[0:len(price)-2] + '.' + price[-2:] item, price, description, discount = stuff[2], price, stuff[3], stuff[8] order += 'Item #: ' + item + '\tQuantity: ' + quantity + '\tPrice: ' + price + '\tDiscount: ' + str(discount) + '\tDescription: ' + description[:20] + '...<br />\n' print 'Total 1: %s<br />' % total total += float(price) * int(quantity) * (100 - discount)/100 print 'Total 2: %s<br />' % total order += 'TOTAL: $' + str(total)
It prints out the following to screen with the print statements: Total 1: 0 Total 2: 1.98 Total 1: 0 Total 2: 6.3 As you can see, the total doesn't accumulate! There are two rows. The second "Total 1:" should show "1.98", not 0! What gives? TIA, Victor
-- http://mail.python.org/mailman/listinfo/python-list