Hello,
I need to create a database that will display the following info in my website: http://coastalconstruction.com/completedprojects.html
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 http://visuallightbox.com/photo-gallery-with-lightbox-simple-html-demo.html
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: http://coastalconstruction.com/completedprojects.html the only different is that my will have an extra column for the picture.
Please use MySQL to develop the database.
Thank you