Eric, Generally you would store references to the images in the database as a full or partial pathname.
You can store binary data in the db itself using the BLOB type but this is not necessarily the most efficient approach to take John Lodge -----Original Message----- From: Eric Torr Klopper [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: Images in MySql Hi all. Eric here from South Africa. I'm fairly new at using mysql and need to access images via a php website. What is the best way to store images or reference to images like jpg and gifs in a mysql db? Also what would the sql querie look like to call the and view the image. Is there any documentation specificaly geared towards to images in mysql. Any help on the matter would be greatly appreciated. Thank you Eric Torr Klopper Thrasher Technologies +27 82 219 3994 --------------------------------------------------------------------- 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
