Originally Posted by lamerhooD

$query = "select id, content from big_table_of_images";
// do some nifty for loop or while loop, doesn't matter...
// inside that, use the gd library to resize on the fly
// then update big_table_of_images set `content` = $new_size where `id` ='$row['id'].';

not too hard, maybe 10 minutes worth of work. but i'll say again, you will be able to scale much better if you keep it out of db and simply reference it...

goodluck