August 25th, 2000, 09:33 PM
I ahve a site that I want to display videos in. The videos have name - stock number and description - also they fall under categories. The trouble is they can fall under several categories - hoe do I achieve this while keeping the data small and overheads to a minimum - at the moment I have a table saying cat_id and categories - but I pressume I can only falg one in the video_id - Help is appreciated as I am still learning.
August 26th, 2000, 10:27 AM
If the video's have multiple categories then you'll need to set up an extra table that stores the one to many relationship. The table only needs 2 fields: cat_id and vid_id. cat_id should not be a part of the video records.