Printing a drop down menu for a specific field.
Νίκος Αλεξόπουλος
nikos.gr33k at gmail.com
Mon Oct 21 02:07:17 EDT 2013
Στις 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.
More information about the Python-list
mailing list