From: Robert Hazeltine Date: March 14 1999 9:51am Subject: Displaying image from database List-Archive: http://lists.mysql.com/mysql/197 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hi I am working on a project whereby all the relevant data is stored in the Mysql database and then when required the data is compiled into a web page. I have all the text data working properly, but cannot figure out how to display the image BLOBS I have created at the same time, or being able to format them within the appropriate HTML tags. I was hoping I could do something similar to (pseudo-code): # get the image from the database $image = "select image from table where id = foo"; # display the image in HTML I tried many different ways of getting to this, but none of them work. I found an example in a news archive somewhere that lets me display the BLOB direct from the database, but it requires that I pass a lot of the information about the file (content/type &c) myself and it does not let me do any proper formatting on the images layout and nor can I display text in the browser at the same time. Given that I have my image BLOB properly accessible in the database, and I can already pop out any arbitrary text as I wish, what do I do next for images? Thanks Rob... Robert Hazeltine Member of UWSN Web Management Group Project Officer (Web Development) Phone: +61 (2) 4736 0218 Central Administration Email: r.hazeltine@stripped University of Western Sydney, Nepean http://www.nepean.uws.edu.au/