import sys
import cgitb; cgitb.enable()
import MySQLdb
sys.stderr = sys.stdout
print "Content-Type: text/html\n\n"
conn = MySQLdb.connect(user="xxx",passwd="xxx")
conn.select_db("usa")
curr = conn.cursor()
numrecs = curr.execute("select statename, abbrev, postal, capital from states;")
recs = curr.fetchall()
conn.close()
print "<html>"
print "<head><title>Contents of states table</title></head>"
print "<body>"
print '<table width="400" border="0" align="center">'
for record in recs:
print '<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>' % record
print "</table>"
print '<div align="center">'
print "<a href='../ocn/geoquiz.html'>Return to geoquiz home page</a>"
print "</div>"
print "</body>"
print "</html>"
# code highlighted using py2html.py version 0.8