A photo album is something to learn SQL with. There's not much learning experience in buying or downloading one. Blobs looked like something interesting to play with. After pictures then there's sounds and executables and ISOs. Who knows where it will end. >>> [EMAIL PROTECTED] 2/22/2001 7:22:47 PM >>> |I'm using Apache/PHP/MySQL to learn SQL. Besides dazzling |people with my prowess, I'd like to be able to store digital |pictures in the database. So far, I've gotten to the chapter |that creates a form to type in a product code, description and |price. Yawn. |Does anyone know the SQL code to insert a binary file into a |MySQL database? What type of field does it take? I didn't see |mention of a blob. Maybe that's the next book. is there a certain reason you want to put images in the database? I usually just store the image in the filesystem then call it from the webpage using PHP/SQL (via the name): <img src="<? $imagename; ?>.gif"> as a simple example. if you are trying to create a photo album then take a look at slooze (www.slooze.com). I have used it for my family photo album for over a year and am rather impressed with it. Also, the support is awesome and the code is well written. /frank
