From: Tommi Rintala
Date: March 17 1999 10:13pm
Subject: Re: Displaying image from database
List-Archive: http://lists.mysql.com/mysql/451
Message-Id: <199903172213.AAA11098@kontio.sevensoft.com>
Content-Type: text

Attachment: <a href="/mysql/451/1">[text]</a><br />
> 
> 
> Rob, how about storing the full paths of the images in the database and inserting them into your HTML pages? That would also cut down on your DB size a little!
> 
> --Chris
> 

If you are going to store diffrent kind of images, I will suggest you
(one) solution, if youre images are bigger than 120kb:

1) store the image type (Content-Type: image/gif) to database
2) store the image size (bytes) to database
3) store the image data to a file
4) store the filename to database (like mySQL)

for image query, just write short cgi-bin script, which will query the
name, size and type of image and will write it (with content-type and
size) to STDOUT from filename (from database).

t
-- 
	<------------------------------------------------------------->
	<  Tommi Rintala t2r@stripped http://www.sevensoft.com/  >
	<  Sevensoft Oy, BOX 28 FIN-65201 VAASA, FINLAND, EUROPE      >
	<  Tel: +35863207321  Mob: +358505633142  Fax: +3585085633142 >