In sqlite 3 I want to use two "WHERE" statements, here is my code right now
"db.execute("UPDATE portfolio SET shares = :shares WHERE id = :ide",shares = symb[0]["shares"] - number,ide = ide)"
I want to add another where of symbol as this code is changind all shares irrespective of shares, Your help appreciated.#pset7 I also tried this to add symbols in "where" but did not worked.
db.execute("UPDATE portfolio SET shares = :shares WHERE (id,symbol) VALUES (:ide,:smb)",shares = symb[0]["shares"] - number,ide = ide,smb = symbl)