Mysql returning number of rows not data

[AkaAndrew123]

Really odd thing today, when I query a mysql database I am getting the number of rows returned rather that the column data !

#!/usr/bin/python
# -*- coding:utf-8 -*-
import csv
import time
import MySQLdb 
try:
    db = MySQLdb.connect(host="localhost", user="root", passwd="",db="pension")
    cur = db.cursor()
except MySQLdb.Error, e:
    print "Error One %d: %s" % (e.args[0], e.args[1])
    
startdate = "2019-05-18"
enddate = "2019-05-19"
    
print cur.execute("SELECT * FROM pension.pension_payments WHERE date >= %s AND date <= %s",(startdate,enddate))
print cur.execute("SELECT * FROM pension.pension_payments")

Result would be:
4
4
but i have six columns in 4 rows

idpension_payments,date,week,name,employer,employee
69,"2019-05-18 16:47:35",10,Andrew,35.67,20.00
70,"2019-05-18 16:47:36",10,Alex,35.67,11.37
71,"2019-05-18 16:47:36",10,Sharon,35.67,7.05
72,"2019-05-18 16:47:36",10,Kerry,35.67,9.13