Thanx Maxim, I did try this in the past but the problem I had with the method is in terms of updated/deletion particularly when you delegate the job. Which means I can easily just delete the record in mysql but I have to manually look for the particular graphic to delete then it gets mesy when there is a lot of unwanted file. Hummmm, I khow there should be a way to get mysql store the image and update when necessary.
Toks ----- Original Message ----- From: "Maxim Vysotskiy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 8:26 PM Subject: Re: PHP, BLOB file, MySql and my web site > Hello Tokunboh, > > I'm not saving any binary data in database, only saves relative (to > webserver root) image paths there, and then just put them to <img > src=""> tag. > > Wednesday, March 27, 2002, 3:05:35 AM, you wrote: > > OT> Hi All, > > OT> Can anyone guide me on how to list the content of mysql table or result of a > OT> query that has a BLOB file in it on my web page. I am listing the result of > OT> the query OK now, but mysql query is listing the name of the graphic > OT> (image1.gif) file instead of the graphic itself. I am working on a real > OT> estate web site that requires the image of the property along with the > OT> details when searched. > > > OT> Thanx > OT> Toks > > > > OT> --------------------------------------------------------------------- > OT> Before posting, please check: > OT> http://www.mysql.com/manual.php (the manual) > OT> http://lists.mysql.com/ (the list archive) > > OT> To request this thread, e-mail <[EMAIL PROTECTED]> > OT> To unsubscribe, e-mail <[EMAIL PROTECTED]> > OT> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- > Best regards, > Maxim mailto:[EMAIL PROTECTED] > > > --------------------------------------------------------------------- > 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