I need to create a database that will display the following info in my website: [url removed, login to view]
The name: Mid and High Rise Condominium Project, Hotels, Specialty Buildings (This are the category names, then under each category I will have the “project, Location, Client and I need a new column IMAGES. Here you only need to show one small photo from the ones at the photo album and ones the user click the icon, I will like the photo gallery to pop up using light box style photo gallery like [url removed, login to view]
I need to be able to upload a maximum of 10 images
I need to be able to add, edit and delete any category and any content in the database so I need an administrator interface where I can login to create categories, upload pictures, delete or edit current content. This will need a user name and password for the admin interface
The website view of the database will be the sample format and color from the one here: [url removed, login to view] the only different is that my will have an extra column for the picture.
Please use MySQL to develop the database.