Fairly simple photo retrieval script needed. See below for outline.
MySql DB contains these fields:
Image Table: ID Number / Image Name / Approved / Views
Visitor Table: User Email / ID Number / Date
-Guest visitor enters their email address and an "id number".
-guest info stored in VISITOR TABLE
-if ID Number is not found, an error page is displayed
-if ID Number is found, but Approved field is empty or marked NO, an error page is displayed
-if the "id number" is found, and approved field is YES, image is diplayed and a count is added to the Views field
-a "diplay page" is displayed showing the image...guest has the option to download the image, or EMAIL TO A FRIEND
-EMAIL TO A FRIEND sends a link to the image page to the email address provided, with the guest email address (from step 1) as the FROM field.
Also...the "Image Name" field should be able to contain multiple image names. If more than one name exists, the guest will see a "multiple image page" of thumbnails of the images. Clicking the thumbnail will display the "diplay page" for that image.