RE: [PHP-DB] Another Image prob

The consensus is that it is best if you DO NOT store the images as blobs in a database. Rather, store the images in separate files and store the names of those files in the database. Then retrieve the file names for the database, open the image files, and then send the images to the client's browser. Storing images as blobs tends to make the database unwieldy. -----Original Message----- From: Todd Moy [mailto:metonym@metonym.org] Sent: Friday, September 14, 2001 1:46 PM To: php-db@lists.php.net Subject: [PHP-DB] Another Image prob I'm new at this and i'm sure that this has been answered before, but anyway... I am trying to retrieve images from a MySQL database. They are stored as BLOBs with the following table format: Database metonym_metonym - table imgs Field Type Attributes Null Default Extra fk_proj_id int(3) No 0 imgname varchar(30) imgtype varchar(20) img blob Keyname Unique Field PRIMARY Yes fk_proj_id Is it possible to do this with a printf/ img src statement? Also, I have heard some talk about header information on retrieval-> how does this relate to retrieving an image? Bear in mind that these images are being uploaded via HTML form Thanks in advance METONYM -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net