hi :)
I need some help for this script
I have

cursor = conn.cursor()
cursor.execute("select * from playlist limit 5")
result = cursor.fetchall()
# iterate through resultset
playlist_txt = ''
for record in result:
 mp3id = record[0]
 mp3_title = record[1]
 mp3_artist = record[2]
 playlist_txt += mp3id + mp3_title + mp3_artist
 #print mp3id , " - ", mp3_title , ' - ', mp3_artist , "<br />"

#and want to print this out of "for record in result:"

print playlist_txt

#but there is an error in

playlist_txt += mp3id + mp3_title + mp3_artist

10x in advance :)))

Recommended Answers

With Python questions, you definitely need to use CODE tags.

Jump to Post

All 4 Replies

With Python questions, you definitely need to use CODE tags.

sorry but I write here for the first time
Now I know 10x

Can you give us the error message and a little more of your code?

Without that info, I don't know what your resultset looks like. I can only assume that mp3id could be an integer and needs to be converted to a string to work with the + concatination. In this case mp3id = str(record[0]) would do the trick.

10x for the help
I try with this and it work perfect :))

playlist_txt += str(mp3id) +  str(mp3_title) + str(mp3_artist) + '<br>'
#playlist_txt += "%s %s %s <br>" % (mp3id, mp3_title, mp3_artist)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.