Formatting a column's value output

[Virgil Stokes]

On 27-Jan-2013 17:12, rurpy at 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.