How to fix error with getting sql data in python?

Question

Python

my code:

a = "Ваш баланс: " + str(sql.execute(f"SELECT money from users WHERE id = '{user_id}'")) + "$"
print(a)

he returns

Ваш баланс <sqlite3.Cursor object at 0x000001FBCA70AD50>$

How to fix it?

Answer 1

First of all, this is not a mistake. Secondly, execute in python, like in any other language, returns a fetch object. To pull information from there, you need to use the .fetchall () function.
For example:

cur.execute("SELECT * FROM table")

    rows = cur.fetchall()

    for row in rows:
        print(row)