Printing a drop down menu for a specific field.

Νίκος Αλεξόπουλος nikos.gr33k at gmail.com
Sun Oct 20 19:30:33 EDT 2013


try:
	cur.execute( '''SELECT host, city, useros, browser, ref, hits, 
lastvisit FROM visitors WHERE counterID = (SELECT ID FROM counters WHERE 
url = %s) ORDER BY lastvisit DESC''', page )
	data = cur.fetchall()
		
	for row in data:
		(host, city, useros, browser, ref, hits, lastvisit) = row
		lastvisit = lastvisit.strftime('%A %e %b, %H:%M')
			
		print( "<tr>" )
		for item in (host, city, useros, browser, ref, hits, lastvisit):
			print( "<td><center><b><font color=white> %s </td>" % item )
except pymysql.ProgrammingError as e:
	print( repr(e) )
===========================================

In the above code i print the record of the mysql table visitors in each 
row like this:  http://superhost.gr/?show=log&page=index.html

Now, i wish to write the same thing but when it comes to print the 
'lastvisit' field to display it in a <select></select> tag so all prior 
visits for the same host appear in a drop down menu opposed to as i have 
it now which i only print the datetime of just the latest visit of that 
host and not all its visit datetimes.

I hope i made it clear what i want to achieve.



More information about the Python-list mailing list