Prob. w/ Script Posting Last Value

Victor Subervi victorsubervi at
Thu Apr 17 18:22:09 CEST 2008

Gabriel provided a lovely script for showing images which I am modifying for
my needs. I have the following line:

print '<img src=""><br /><br /></td>\n' % (d, y)
where the correct values are entered for the variables, and those values
increment (already tested). Here is the slightly modified script it calls:

import cgitb; cgitb.enable()
import MySQLdb
import cgi
form = cgi.FieldStorage()
picid = int(form["id"].value)
x = int(form["x"].value)
pic = str(x)
print 'Content-Type: text/html'
db = MySQLdb.connect(host=host, user=user, passwd=passwd, db=db)
cursor= db.cursor()
sql = "select " + pic + " from products where id='" + str(picid) + "';"
content = cursor.fetchall()[0][0].tostring()
print 'Content-Type: image/jpeg\r\nContent-Length: %s\n' % len(content)
print content

I need to make it so that it will show all my images, not just the last one.
Suggestions, please.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Python-list mailing list