i am working on a website that will display projects and many images for each project.
i want to make an interface for the website admin to login and add new projects and images for each project.
i was wondering whats the best way to store the images in the mysql database and assign them to a project an then display the project with a slideshow next to it that shows all images for this specific project.
i decided to make 2 tables, one for projects (projID projName and projDesc) and the other for images (imgID imgName projID)
in the imgName field i will store the image name, and in the php code i will display the path which is always the same and get the image name from the database.
is everything i said make sense so far?
i know how to upload an image and attach it and send it as an email
but i dont know how to upload the image to the directory, and store the name of the image in the database in imgName field to retrieve it later with php
if you know any tutorial or article or sample code please help...
thanks a lot