#!/usr/bin/python2.3 -u
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") # actual values concealed
conn.select_db("usa")
curr = conn.cursor()
numrecs = curr.execute("select statename, abbrev, postal, capital from states;")
recs = curr.fetchall()
conn.close()
print ""
print "Contents of states table"
print ""
print ''
for record in recs:
print '| %s | %s | %s | %s |
' % record
print "
"
print '"
print ""
print ""