MySQLdb rowcount Returns Nothing
- by Alec K.
I am trying to log into my table called acounts using MySQLdb in Python, but it does not work for me. I keep getting my message "Not Logged In". Here is my code:
database = MySQLdb.connect("127.0.0.1", "root", "pswd", "Kazzah")
cursor = database.cursor()
cursor.execute("SELECT * FROM Accounts WHERE Email=%s AND Password=%s", (_Email, _Password))
database.commit()
numrows = cursor.rowcount
if numrows == 1:
msg = "Logged In"
else:
msg = "Not Logged In"
cursor.close()
database.close()
What am I doing wrong? Thanks.
