Printing a drop down menu for a specific field.

[Νίκος Αλεξόπουλος]

Στις 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.