saving images from mysql to file

2001-02-06 Thread Phillip M.(Mike) Bishop

How do I save an images to a unix file that is saved in mysql? I know how to view the 
image with PHP and I know how to write a file to unix. I just can't get the data from 
mysql into a format that will allow me to read it then write it.

-
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




Re: saving images from mysql to file

2001-02-06 Thread Phillip M.(Mike) Bishop

Ok I have 2000 images in a database that I want to move out of the database and save 
the image as a file and place the url to the image in the database. But I can\'t 
figure out how to get them out and written to a file to do this.

You Wrote:
Firstly, I\'m not exactly sure of what you are trying to do but in any
case
check out the blob column type in the mysql manual.  Also, you are
probably
better off storing the image on disk and only store the URL in the
database.

Whichever the case, good examples can usually be found at
www.devshed.com

- Original Message -
From: \"Phillip M.(Mike) Bishop\" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001 4:01
Subject: saving images from mysql to file


 How do I save an images to a unix file that is saved in mysql? I know how
to view the image with PHP and I know how to write a file to unix. I
just
can\'t get the data from mysql into a format that will allow me to read
it
then write it.

-
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