Alan,
I am in the same situation as you... What you are after is almost exactly what I was planning on making (or finding)... The reason I would like to setup such a system is so that I can post pictures (via a web page) from my digital camera while I am travelling overseas.
I have seen a few snippets here and there on the subject of image resizing etc but nothing that has a MySQL component included. I imagine it wouldn't be too hard to build that in though... Getting back to the image functions and Imagemagick - there seems to be a (comparitive) lack of resources out there on this topic... I must admit I need to search further but so far I haven't come up with that much so far.
If anyone out there has any functions/code snippets that they are willing to share I'd be very greatful... ๐
PS: I leave in a week so the sooner the better!