Displaying Images In MySQL

[BatstangGT]

Ladies and Gentlemen my question is..How do you create a slide show of BLOBs that are stores in a mysql database? There is little or no information on this topic it seems. Only ways to store links to images in the file system which im trying to avoid. Any help would be great thanks guys.-SB

[justsomeguy]

To output binary data from a blob field you need to first send all of the appropriate headers for the data, then send the data. The script can send no other output except the headers and data for a single file. For an image, you would send a content-type header saying what kind of image it is, a content-disposition header if people should download the file, content-length, etc. There are several examples of PHP download scripts online, it's the same concept even if you're displaying the image on a page. The image URLs should all point to a PHP script that tells it which image to get in the database.