BLOB display in flash

[rezzkilla]

First, please do not post about using a file system for images rather than
storing them in mysql as I know how to do this and I want to store the images
in a database. If you can explain more of the security of a file system then I
will listen as that is the only issue I'm having with the file system. However,
all I want to know is how to take an image in a blob field in a mysql database
and display it in a flash movieclip. I can use php to echo the image straight
to a browser no problem. I've read I may have to create a temporary image on
the server and display that, but there is little documentation, actually none,
aside from using a file system on how to handle images in mysql and display
them in flash. Please advise as I can't believe it's this difficult to display
an image in flash from a mysql database.

[Gorka Ludlow]

You simply need to load the image into a loader component, loader components
can dynamically display imagexs using the contentPath and load property/method.
Just direct the contentPath property to the php that writes the image into the
page.

Cheers,
Gorka
[url]www.AquiGorka.com[/url]

[rezzkilla]

Thanks for the reply. It answered my question, but left me wondering how to
load multiple images. Do i have to call the same php file and string a
different variable for multiple instances of the component? Such as:

loader1.contentPath = "pics.php?&picid="+picnumber+"";
loader2.contentPath = "pics.php?&picid="+picnumber2+"";

It seems like hell for the php file on the server with all the request. Is
there a way to get all the pictures I need with one call to one php file?
Please advise.

[Gorka Ludlow]

I have never tried it before, but you could write all the images to the php
(&var1=a&&var2=b&&var3=...&) and read them inone single loadvars (or xml) and
then store them in an array for further use.

Cheers,
Gorka
[url]www.AquiGorka.com[/url]

[rezzkilla]

Thanks again for the reply. I'm going to mark your first reply as the answer as you've given me enough to mess around with.