#!/usr/bin/python
"Show page with picture and titles"
import cgi
import sqlite3
form = cgi.FieldStorage()
picid = int(form["id"].value)
conn = sqlite3.connect("demo.db")
cursor = conn.cursor()
sql = "select title, description from album where id=?"
cursor.execute(sql, (picid,))
title, description = cursor.fetchone()
conn.close()
print "Content-Type: text/html"
print
print "%s" % cgi.escape(title)
print ""
print "%s
" % cgi.escape(title)
print "
" % (picid, cgi.escape(title))
print "%s
" % cgi.escape(description)
print "Back to album
"
print ""