select statement for python-mysql

hi,

im facing a problem with the syntax in python-mysql. this is my code:

c.execute("""select vid from verses where book,chapter,number=%s,%s,%s""",(bk,chap,i))

and i get the error as :"u have an error in your SQL syntax near chapter,number=1,21)

someone pls help me here. thanks alot

regards,

roslyn



---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com