In case you want to see the whole view function please take a look at:
# ================================================================================================================= # search & display requested info based on name/month/year criteria # ================================================================================================================= @app.route( '/seek', methods=['GET', 'POST'] ) def seek(): pdata = '' name = request.args.get('name') month = request.args.get('month') year = request.args.get('year') try: if '=' not in name + month + year: cur.execute( '''SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = %s) and MONTH(lastvisit) = %s and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (name, month, year) ) elif '=' not in name + year: cur.execute( '''SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = %s) and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (name, year) ) elif '=' not in month + year: cur.execute( '''SELECT * FROM jobs WHERE MONTH(lastvisit) = %s and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (month, year) ) elif '=' not in year: cur.execute( '''SELECT * FROM jobs WHERE YEAR(lastvisit) = %s ORDER BY lastvisit ASC''', year ) else: pdata = pdata + "<h2><font color=red>Πώς να γίνει αναζήτηση αφού δεν επέλεξες ούτε πελάτη ούτε μήνα ή τουλάχιστον το έτος?" data = cur.fetchall() hits = money = 0 for row in data: hits += 1 money = money + row[2] pdata = pdata + ''' <body background="/static/img/pelatologio.jpg"> <center><h2><font color=yellow size=5> Απολαβές από </font> <font color=lime size=5> [ %s - %s - %s ] </font> <br><br> <font color=white> Επισκευές: <font color=violet> %s </font> Σύνολο: <font color=orangered> %s € </font> <br><br> <table border=5 cellpadding=5 bgcolor=black> <th><u><font color=lime size=5> Πελάτης </th> <th><u><font color=tomato size=5> Περιγραφή </th> <th><u><font color=cyan size=5> Αμοιβή </th> <th><u><font color=orange size=5> Ημερομηνία </th> ''' % (name, month, year, hits, money) for row in data: (clientID, task, price, lastvisit) = row cur.execute( '''SELECT name FROM clients WHERE id = %s''', clientID ) data = cur.fetchone() name = data[0] lastvisit = lastvisit.strftime('%A, %e %b %Y') pdata = pdata + ''' <tr> <td><center><font color=lime size=5> %s </td> <td><center><font color=tomato size=5> %s </td> <td><center><font color=cyan size=5> %s </td> <td><center><font color=orange size=5> %s </td> </tr> ''' % (name, task, price, lastvisit) except pymysql.ProgrammingError as e: print( repr(e) ) pdata = pdata + "<meta http-equiv='REFRESH' content='200;%s'>" % url_for( 'index' ) return pdata