On 27-Jan-2013 17:12, ru...@yahoo.com wrote:
On 01/27/2013 02:04 AM, Ferrous Cranus wrote:
[...]
                data = cur.fetchall()
                for row in data:
                        print ( "<tr>" )
                                
                        for item in row:
                                print( '''<td>  <a 
href='http://www.%s?show=log'>%s</a>  </td>''' % (item, item) )
[...]
Okey, so far BUT i want the url linking to happen only for the URL column's
value, and not for the hits column too. How do i apply the url link to the
URL column's value only?
Ferrous,

'row' has two items (the url and the hit count) in it, right?
So print each separately rather than in a loop:
data = cur.fetchall()
     for row in data:
        url = row[0]
        hits = row[1]
         print ( "<tr>" )
         print( "<td>  <a href='http://www.%s?show=log'>%s</a>  </td>: % (url, 
hits) )
It is nice to see some constructive feedback to Ferrous from the python-list. This will hopefully help to get Ferrous on the right track.
--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to