Good Morning:
I have a managed Server with 1and1 and although I have read some negatives regarding them, I have not had one single solitary problem, though I do have a dilema that maybe someone can help me with.

I have a website with over 2000 photos posted by my members. The photos run off a my.sql database and the posting of photos by my members and the subsequent approval of them etc is quite time consuming. Also this was a script / database built from scratch my my programmer.

What I really need is a script / Software gallery that runs with PHP, off a my.sql database on a linux server. I can not add software to the managed server of 1and1 so it must be some sort of script.

I do not mind paying for the proper item, but I need ease of use to add categories as well as setting upload limitations on size along with multible upload capabilities. It should also have a search engline for my members.

I have done some searches but get back so many hits my head is spinning. Anyone who can reccomend something It would be appreciated.

You might check out the Snaps! Gallery (http://labs.sonicdesign.us/projects/Snaps!/)

Thanks, I 'm looking for something a bit more robust willing to pay!

Photopost will do what you want, as will Coppermine.

http://www.photopost.com/

http://coppermine.sourceforge.net/

You might also take a look at Photo gallery software (http://forums.iwdn.net/viewtopic.php?t=1869)

Also check this:
http://hotscripts.com/PHP/Scripts_and_Programs/Image_Galleries/index.html