I require the following ASP pages to access the database i have:
It's for a market stall holder database.
CATEGORIES TABLE with the following:
STALLHOLDERS TABLE with the following:
FieldNames: StallID,CategoryID(linked to CategoryID),StallName,StallDescription,StallURL,StallContact,StallNumber,StallPhone,StallPhotoURL,StallPhotoID,StallWebsite(Y/N)
Basically, I would like the categories to be listed as a menu and when a category link is clicked, I would like it to display all the stalls in that category along with all stall details and photo in a manner similar to the site [url removed, login to view] . If the photo is clicked I would like the thumbnail to enlarge to a full sized photo.
I would also like a admin area with username/password to amend, delete and add new stalls.