retrieving field values from a row in mysql

roslyn jose <[email protected]> Tue, 1 Oct 2002 02:28:53 -0700 (PDT)
Newsgroups gmane.comp.python.meta
Message-ID <[email protected]>
hi,

im working with python-mysql and have a problem with retreiving a particular field value from a selected row. this is my bit of code. if someone here could help me out, it would be greatly appreciated. thanks.

/*

c.execute("""select name,chapters,lang from books where name=%s""",x[3])
bk=c.fetchone()
print bk

*/

here  bk holds an entire row, how do i access each induvidual item in that row? i tried treating it like an array, bk[0],bk[1]...but it doesnt work..


 



---------------------------------
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!