"WHERE players.player_name=%s AND levels.level_id=%s", (player_name, level_number)) best_score = [(row[0]) for row in cursor.fetchall()] # If length isn't greater than 0 there is no existing best score if len(best_score) > 0: return best_score[0] else: return None if __name__ == "__main__": # Turn on debug mode cgitb.enable() # Print necessary headers print("Content-Type: text/html; charset=utf-8\n\n") form = cgi.FieldStorage() player_name = processing.get_player_name(form) level_number = processing.get_level_number(form) if player_name is not None and level_number is not None: best_score = get_best_score(player_name, level_number) if best_score is not None: print(json.dumps(best_score)) else: # If score doesn't exist for that player/level print(json.dumps(None)) else: # If player/level not provided print(json.dumps(None))