self.terr_list_drop = QtGui.QComboBox(self.centralwidget)
self.terr_list_drop.setGeometry(QtCore.QRect(20, 90, 161, 21))
self.terr_list_drop.setObjectName(_fromUtf8("terr_list_drop"))
self.terr_list_drop.addItem(_fromUtf8("All Cards"))
self.terr_list_drop.addItem(_fromUtf8("Available Cards"))
self.terr_list_drop.addItem(_fromUtf8("Unavailable Cards"))
self.terr_list_drop.activated[str].connect(self.card_query)
self.terr_list_view_btn = QtGui.QPushButton(self.centralwidget)
self.terr_list_view_btn.setGeometry(QtCore.QRect(200, 90, 75, 23))
self.terr_list_view_btn.setObjectName(_fromUtf8("terr_list_view_btn"))

self.connect(self.terr_list_drop, QtCore.SIGNAL('activated(int)'), self.setCurrentIndex)

def cards_unavailable():
 c.execute("SELECT * FROM Cards WHERE CheckStatus='Out'")
 data = c.fetchall()
 for row in data:
 print("CardID: ",row[0])
 print("Status: ",row[1])
 print("PubID: ",row[2])
 print("Last Checked Out: ",row[3])
 print("Last Checked In: ",row[4])

def cards_available():
 c.execute("SELECT * FROM Cards WHERE CheckStatus='In'")
 data = c.fetchall()
 for row in data:
 print("CardID: ",row[0])
 print("Status: ",row[1])
 print("PubID:",row[2])
 print("Last Checked Out: ",row[3])
 print("Last Checked In: ",row[4])

def cards_all():
 c.execute("SELECT * FROM Cards")
 data = c.fetchall()
 for row in data:
 print("CardID: ",row[0])
 print("Status: ",row[1])
 print("PubID: ",row[2])
 print("Last Checked Out: ",row[3])
 print("Last Checked In: ",row[4])