Mike, > Has anyone done any work with getting images into and out of a MYSQL > database? I have used mysql for some time, but never stored an image in a > blob field. I am curious on how to insert the image from a web form upload, > and how to display the picture on another HTML page.
You might want to start here: http://www.mysql.com/doc/en/String_functions.html. Look for LOAD_FILE. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Mike Walth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 9:26 AM Subject: Getting Images in and out of a Blob > Has anyone done any work with getting images into and out of a MYSQL > database? I have used mysql for some time, but never stored an image in a > blob field. I am curious on how to insert the image from a web form upload, > and how to display the picture on another HTML page. Preferred web > scripting is ColdFusion, but PHP/PERL would be helpful too. Thank you for > your help. > > Mike Walth > CinoFusion > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php