I've decided not to use a BLOB to store the image for my gallery. I've created a directory structure (with no DB transactions at all)... its pure file system. For example i've created the following file structure:
The folder is divided into male and female. The letter "S" being the first letter of the email address and the hash being unique to each user. So if you can see what im doing is making a easy to search file structure. My concern is on security. I've updated my .htaccess file to include option-indexes which means no directories will be directly shown but is this the best way to be doing this ? i see other sites using CGI and a photoID etc ..i need some guidance.