Στις 21/10/2013 2:30 πμ, ο/η Νίκος Αλεξόπουλος έγραψε:
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.
Any help would be appreciated. -- https://mail.python.org/mailman/listinfo/python-list
