about once a quarter this question comes up and the answer is always the same. Don't store them in the database, just store filenames and store the files in the filesystem. That way you just generate a link and treat it like any other image. Then when you query the database you would create img tags with src property set to the image. You probably don't want to store FULL path info, just enough to find the image. <>< Ryan -----Original Message----- From: John T. Beresford [mailto:john-nic@xxxxxxxxxxxxx] Sent: Monday, January 26, 2004 2:23 PM To: php-db@xxxxxxxxxxxxx Subject: Images stored in a db - how to get them? Hello All, I am interested in storing images in a table. My question is - What is the proper way of retrieving the images and displaying them on a web page? Will I need to go through the GD library and create an image from the information stored in the table? While PHP is not new to me, images in db's is. Specifically, when info is returned, it's usually in the form of: $var=$row['FieldName']; What would I then do with the 'BLOB' information? Is that where the GD image tools come in play? Any URL's or small hints to point in the right direction would be very much appreciated. Thanks, John -- =========================== John T. Beresford Apple Certified Technical Coordinator http://www.deewi.com/ 405.760.0794 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
