[Tutor] Some help Please

[JOSEPH MARTIN MPALAKA]

take an example of updating Bank Accounts,
gaving the following table:

acc_id		acc_name	    standing_Balance
mn0001		computer	     20000

my problem is how can i credit the standing balance from user data,as
in making a deposit onto the computer account, using the code below:-



import MySQLdb as mdb
import sys

con = mdb.connect('localhost', 'joseph', 'jmm20600', 'savings');

dep = input('Enter Amount: ')

            cur.execute("UPDATE accounts SET Standing_Amount =
(Standing_Amount + dep) WHERE Acc_ID = 'MN0001'")

	    conn.commit()

HOw do i format "dep" in order to be added onto the standing_Amount,to
make an increment?

Please, is it the same thing with the withdrawing format, in case i
want to decrement the account as in withdrawing??


joseph









-- 
MY BEING was HIS BEING.  Of what is magnificent and liked of me, this
was him too. In VAIN, I will always miss u,thou i live with YOU in
vain.
                   Lt.Col.Sam .E. Lukakamwa  (DADDY)



-- 
MY BEING was HIS BEING.  Of what is magnificent and liked of me, this
was him too. In VAIN, I will always miss u,thou i live with YOU in
vain.
                   Lt.Col.Sam .E. Lukakamwa  (DADDY)



-- 
MY BEING was HIS BEING.  Of what is magnificent and liked of me, this
was him too. In VAIN, I will always miss u,thou i live with YOU in
vain.
                   Lt.Col.Sam .E. Lukakamwa  (DADDY)