Posted by Bugz on 09/26/77 11:27

A) You probably wouldn't want to store the image in th DB in the first
place
B) Since you've done that, save the image in the /tmp/ forlder after
reading it from the DB, resize that image and display it on the page.
C) If you plan on having lots of visualizations of the thumbnail,
you'll most probably want to save the image for future use... do this
by either :
1 - updating the DB with a pointer to the resized image
2 - Check if the file name of the thumbnail exists in a give Directory
before processing the image.

Preferably, you'd want to store a pointer in the DB of both the Thumb
and the main image.This way, you transfer less data between PHP and
MySQL, hence making your code quicker to execute.

[Back to original message]