SQLite Select query gives no errors but does not display results
<p>Basically what i want to do is return entries from a database based on the user's input and display the records in PyQt4's textBrowser widget. </p>

<p>This is the code:</p>

<pre><code>    def url_search(self):
        self.browserUrl.append("Look") \\ for testing reasons, works.
        items = []
        for index in range(self.listUrl.count()):
             items.append(self.listUrl.item(index))
             conn = sqlite3.connect(directory + '\\CyberConan Databases\\CB Database\\Google Chrome\\Chrome Artifacts.db')
        for kw in items:
            self.browserUrl.append("it is") \\for testing reasons, works
            x = str(kw)
            for row in conn.execute("SELECT * FROM urls WHERE ID LIKE ? OR URL LIKE ? OR Title LIKE ? "
                                "OR Visit_Count LIKE ? OR Typed_Count LIKE ?;",
                                ("'%"+x+"%'", "'%"+x+"%'", "'%"+x+"%'", "'%"+x+"%'", "'%+x+%'")):
                 self.browserUrl.append("working") \\ for testing reasons, does not work
                 self.browserUrl.append(str(row[0]))
                 self.browserUrl.append(str(row[1]))
                 self.browserUrl.append(str(row[2]))
                 self.browserUrl.append(str(row[3]))
                 self.browserUrl.append("working man!") \\ for testing reasons, does not work
                 self.browserUrl.append(str(row[4]))
                 self.browserUrl.append(str(row[5]))
</code></pre>

<p>So the user would press a Button and this function runs. The only output im getting is:</p>

<blockquote>
  <p>Look</p>
  
  <p>it is</p>
</blockquote>

<p>This output is occurring every time the button is pressed. All the naming is correct. I get no errors. The table does contain what the user is searching for, so there should be output. Note that "it is" appears for as many kw there are in items.</p>

<p>(This is for a graduation project)</p>