resizing an image stored in SQL

[microphonemark]

Hi!

I have a jpg image stored in a database. I know how to retrieve the image and display it, and I also know how to resize (thumbnail) an actual file stored on the server (imagecopyresized combined with fopen)

What I want to do it print a thumbnail of an image stored in SQL. I don't want to do it using HTML (the VERY bad way) and I don't want to have to output the binary to a file and resize from that.

I KNOW it must be possible to import a binary to a variable in PHP then resize the image in the variable, so I must be doing something wrong. Has anyone done this before?

[cheese]

Have you tried;

http://www.php.net/manual/en/function.imagecopyresized.php

or

http://www.php.net/manual/en/function.getimagesize.php

Might help.

Neil.

[microphonemark]

After much research, I've found the problem. All functions that deal with importing images to your php script presume you're opening from a file. All, except one. Anyone else with this problem should research the function: ImageCreateFromString. It allows you to create an image from a variable imported from a database.