def get_score_in(low, high): try: conn = sqlite3.connect(db_file) cursor = conn.cursor() cursor.execute(r'select * from user where score>=? and score<=?', (low, high)) values = cursor.fetchall() values.sort(key=lambda x:x[2]) names = [v[1] for v in values] print(names) return names finally: cursor.close() conn.close()
Sign in to make a reply
_Dvel