Image Resizing and uploading into MySQL

[runar56]

Hi,

I have a script where I can upload pictures into my mysql table as a blob. I can upload the image no problem. But I have a seperate table for thumbnails for pics aswell. What I am interested in knowing is how do you insert the original image into 1 table, but resize it and put the thumbnail in another as another blob.
What I also want to be able to do is retrieve it out on my site. It's Basically like an image gallery. On the front page you have a thumbnail, click on it and you have the actual picture along with some information.

I've got all the tables set and the forms. I just need the script and query to resize the image submitted from the form, whilst still inserting the original into a table, along with all the other information(description etc.)

Make any sense?😕
Thanks

[nemonoman]

look into [man]image[/man] functions

[runar56]

Thanks for your reply. I found a function which I tihnk might be usefull. Imagecopyresized(), how would I use this to create a thumbnail and then insert it into a table?

Cheers!