def OnClick(self, event):
        name = event.GetEventObject().GetLabelText()
        cursor= self.conn.execute("SELECT * FROM ELEMENT where SYMBOL==?", (name,))
        elements = cursor.fetchall()
        print elements
        cursor= self.conn.execute("SELECT ATOMIC_NUMBER FROM ELEMENT where SYMBOL = ?", (name,))
        numbers = cursor.fetchone()[0]
        print numbers
        atomicnumber = numbers
        cursor= self.conn.execute("SELECT MOL_NUMBER FROM LINK where ELEMENT_NUMBER = ?", (atomicnumber,))
        mnumbers = cursor.fetchall()
        print mnumbers
        mnum_list = []
        for i in mnumbers:
             mnum_list.append(i[0])
        print mnum_list
    def foo(x):
        mnum_list = range(x)
        glist.extend(mnum_list)
        print glist
        self.t1.AppendText(str(elements[0][0]))
        self.t1.AppendText("\n")
        #self.conn.close()