Hi, You would pull it out using a normal SELECT SQL statement.. But I'm just writing this mail to warn agaisnt using a Access Database to store images. I used to do this for a ASP site, allowing users to upload their own images, and for everyone to view them. Anyway the database started running into troubles, every other day I had to replace the database with a backup due to it getting corrupted, and once the access database reached 5mb I spent more time replacing it then it was actually being used. So I changed my solution to one where the images are uploaded and stored on the webserver and infomation about the images still stored in the access database. This method worked FAR better, and since then I haven't had to replace the access database.
Just my opinion Andrew ----- Original Message ----- From: "Mike Baranski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 27, 2001 4:16 PM Subject: [PHP] Store Image in Access Database > Hi, I'm trying to store a binary file in an access database, I'm using an ole > type, and I think that it's getting inserted OK. My problem is that I don't > know how to pull it out... How do you select the stuff that's in an ole > object out of the database and display it, a jpg, for example. I can't even > get the raw data. I've tried converting it to base 16 and inserting it, but > I still can't pull it out. I know how to do this in mysql, so posting that > won't help. I need to know how to do this with access. > > Thanks > Mike. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
