0

Primarily, I need a table of employees with the following fields: Name, Photo(s), and Bio. So the rest should be easy enough, but I know nothing about databases.... so the photo field I'm assuming should be of the blob type, however I need to have a primary photo, and then additional ones. So I don't know if I need to have those separately and call them into the table or something... reference them... yeah clearly I have no idea. But that's my goal. How do I go about doing it? Thank you in advance.

ALSO: On the Employees page, I need to display a gallery of thumbnails of each employee's primary photo, display the name underneath each photo, and have the thumbnails link to their respective profile pages, which will display everything: name, photo, bio, and then additional photos below.

Edited by caltech: addendum

3
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by nice123
0

If there can be multiple images per employee the best way to do it is create another table to hold the images. It will have 2 columns, the employee ID and the URI to the image. Thus it can have many images listed against one employee. Instead of storing the images in the database, store them in a folder and the database table holds the file path to the image.

0

You will need to create an additional table for images:
ImageID int not null autoincrement,
EmployeeID int not null,
Image blob

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.