Output File ?

[Kessie1971]

Hello I try to find the top 10 albums in the chinook database 18

[deanhystad]

Don't print row[3], print something else. Is there a way to get a loop counter?

[Kessie1971]

i try to create a counter loop
Clearwater Revival tracks 18

[buran]

# Print the results
for n, (albumid, album, artist, tracks) in enumerate(result, start=1):
    print(f'{n}. {album} by {artist} - tracks: {tracks}')

Note, code not tested

[Kessie1971]

I have found the solution

result = cur.fetchall()
count = 0

# Print the results
for row in result:
    count += 1
    print(count, row[1], 'by', row[2], '-', row[3])

[Kessie1971]

Last question eedence Clearwater Revival 18[/output]

[deanhystad]

Formatting the print statement. While you are looking up how to format print commands in python you should also read about the enumerate command.

[Kessie1971]

Thanks i try the Formatting the print statement but can you please give a tip how i can do it

[deanhystad]

Thanks i try the Formatting the print statement but can you please give a tip how i can do it

Google "python print formatting"?

[Larz60+]

couldn't you just replace rows 26 and 27 from post 1 with:

for n, row in enumerate(result):
    print(f"row {n}: {row[n]}")