User Update in Mysql with python

[oguzcan]

Hi,

I have a problem. My library mysql-connector

my code working but doesnt updating table

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

if passentry != "":     query=("UPDATE customer SET passw = %s WHERE mail = %s")     value= (passentry2,mailal)     mycursor2.execute(query,value)     veritab.commit()   elif nameentry != "":     query=("UPDATE customer SET name= %s WHERE mail = %s")     value= (nameentry2,mailal)     mycursor2.execute(query,value)     veritab.commit()   elif surnameentry!= "":     query=("UPDATE customer SET surname= %s WHERE mail = %s")     value= (surnameentry2,mailal)     mycursor2.execute(query,value)     veritab.commit()   else:     pass

[Larz60+]

your if statement is weird.
what if passentry == "" and nameentry == ""
nameentry will never execute nor will the third condition
you should test same variable for different values/ otherwise you should use just ifs, no elifs

[oguzcan]

I solved the problem

[ibreeden]

Good! How did you solve it?