I'm starting my Computing project and am using Python linked via sqlite3 to a database. As part of my project I shall be searching for maths books in the database via name or module etc. I wish to display the results on a GUI in python so need to set variables to the results depending on the amount of results. I assume an list with a for loop setting each value in the list as a id of a book and then retrieving data via the id would work but I don't know how to set the results as the ID.
Would it be anything like (Pseudo Code)
for rows in database: *if row matches search criteria* list[nextFree] = rows[count].ID nextFree = nextFree + 1 count = count + 1