I want to compare the some string with the database table and throw an output in python

Question

#My code

Email="[e-mail]:
Pw="XYZ123"

while True:
if Cr.execute('select * from db1.db where email="+Email+"'AND password="+Pw"):
print("success")
else:
print("Fail")

#The if statement is not comparing and printing success even if email and password are wrong

Answer 1

Probably because your select is working well, but it returns zero answers. You have to count results.