PHP, MySQL, Blob data type

[Alex Yu]

I'm going to store image files in Blob data field. Does anyone know if there is an easy way to use Dreamweaver (or Dreamweaver Extension) to display the image data? Also, can I use Dreamweaver to insert image data? If you can point me to URLs, that will be great.

Thanks,
Alex

[wibble]

why blob type...

its gonna kill your db performance....


"Alex Yu" <ayu168@msn.com> wrote in message
news:bg4994$nae$1@forums.macromedia.com...
I'm going to store image files in Blob data field. Does anyone know if
there is an easy way to use Dreamweaver (or Dreamweaver Extension) to
display the image data? Also, can I use Dreamweaver to insert image data?
If you can point me to URLs, that will be great.

Thanks,
Alex

[David Powers]

Josh wrote:

> I may be off base here, but wouldn't it be easier to store the images
> in a server directory, and then just store the source link and size
> information in the database? I'd think you'd increase performance and
> decrease some of the implementation complexity.

Not off base at all. Absolutely spot on.

Databases are for storing searchable data. Use the DB to store details of
the images and where they are stored, but store the images outside the DB.

--
David Powers
*******************************************
No-nonsense reviews of computer books
[url]http://japan-interface.co.uk/webdesign/books.html[/url]
Save 10% on TopStyle CSS Editor
*******************************************