Everytime i choose a name everything prints up records is from my database if i remove the while loop the name will not appear on the combobox

[A Former User]

self.query = QSqlQuery("SELECT name FROM test_table")
        self.comboBox = QComboBox(self)
        self.comboBox.currentIndexChanged.connect(self.selectionchange)
        #
        while(self.query.next()):
            self.comboBox.addItem(self.query.value(0).toString())    
        #
    def selectionchange(self):
        for count in range(self.comboBox.count()):
            print self.comboBox.itemText(count)
        self.show()

---

Edit by VRonin: in python indentation is essential. use ``` at the beginning and end of your code to highlight it

[VRonin]

Everytime i choose a name everything prints up records is from my database if i remove the while loop the name will not appear on the combobox

Yes, this is the behaviour you coded. what did you want to achieve instead?

[A Former User]

@VRonin everytime i choose a name i only want it to display what i choose eg. like this if i choose "gelo" the chosen name will only appear not all of the name in my query it happens when i choose "gelo" all of the names appears

[A Former User]

@VRonin i think the problem is in the while loop

[mrjj]

@Gelo
Hi its not a bug or problem ?
You ask it to to do so.

self.query = QSqlQuery("SELECT name FROM test_table") // get all names from table

FOR ALL NAMES IN TABLE
ADD TO COMBOBOX EACH OF THEM

    while(self.query.next()): 
        self.comboBox.addItem(self.query.value(0).toString())    

So its very unclear how you want it to work.

• i choose a name i only want it to display what i choose
  So if combox is NOT to have all the names, how can u then choose in the first place.

If u mean like this
List is
A
B
C

You choose B
The list is cleared and now ONLY contains B

But then u cant reselect a new one, say A.
So i dont get your structure or use case.
Unless its oK that user cant select new after first selection.

[VRonin]

said in Everytime i choose a name everything prints up records is from my database if i remove the while loop the name will not appear on the combobox:

for count in range(self.comboBox.count()):
print self.comboBox.itemText(count)

for count in range(self.comboBox.count()):
            print self.comboBox.itemText(count)

this prints all the items

print self.comboBox.itemText(self.comboBox.currentIndex())

prints just the current

[A Former User]

@VRonin Thanks men already solve the problem :)