IndexError: tuple index out of range ----- Python
mysql-python, python, python-2.7
Solution
Probably one of the indices is wrong, either the inner one or the outer one.
I suspect you meant to say `[0]` where you said `[1]`, and `[1]` where you said `[2]`. Indices are 0-based in Python.
Problem
Please Help me. I'm running a simple python program that will display the data from mySQL database in a tkinter form... ``` from Tkinter import * import MySQLdb def button_click(): root.destroy() root = Tk() root.geometry("600x500+10+10") root.title("Ariba") myContainer = Frame(root) myContainer.pack(side=TOP, expand=YES, fill=BOTH) db = MySQLdb.connect ("localhost","root","","chocoholics") s = "Select * from member" cursor = db.cursor() cursor.execute(s) rows = cursor.fetchall() x = rows[1][1] + " " + rows[1][2] myLabel1 = Label(myContainer, text = x) y = rows[2][1] + " " + rows[2][2] myLabel2 = Label(myContainer, text = y) btn = Button(myContainer, text = "Quit", command=button_click, height=1, width=6) myLabel1.pack(side=TOP, expand=NO, fill=BOTH) myLabel2.pack(side=TOP, expand=NO, fill=BOTH) btn.pack(side=TOP, expand=YES, fill=NONE) ``` Thats the whole program.... The error was ``` x = rows[1][1] + " " + rows[1][2] IndexError: tuple index out of range y = rows[2][1] + " " + rows[2][2] IndexError: tuple index out of range ``` Can anyone help me??? im new in python. Thank you so much....