#!/usr/bin/python2.3

print "Content-type: text/html\n\n"

import MySQLdb

conn = MySQLdb.connect (host = "localhost", user = "lwtest", passwd = "lwtest127", db = "test")
cursor = conn.cursor ()
cursor.execute ("SELECT rowid, timestamp, UNIX_TIMESTAMP( timestamp ) AS ts FROM timetest")
rows = cursor.fetchall()

print "<table width='95%' border='1'>"
print "<tr>"
print "<th>Row ID</th><th>Date</th><th>Timestamp</th>"
print "</tr>"

for row in rows:
        print "<tr>"
        print "<td>Row %s</td><td>%s</td><td>%s</td>" %(row[0], row[1], row[2])
        print "</tr>"

print "</table>"

#print "server version:", row[0]
cursor.close ()
conn.close ()