#1
  1. No Profile Picture
    BrainFreeze
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Location
    London
    Posts
    318
    Rep Power
    15
    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.

    Regards

    Ian
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    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.

Similar Threads

  1. multiple categories per product
    By scoutt in forum PHP Development
    Replies: 9
    Last Post: January 20th, 2004, 08:54 AM
  2. Replies: 0
    Last Post: January 4th, 2004, 10:57 AM
  3. updating multiple rows (MySQL)
    By Edison in forum PHP Development
    Replies: 2
    Last Post: October 3rd, 2003, 09:05 AM
  4. assign article to multiple dymanic categories
    By jjkice in forum PHP Development
    Replies: 1
    Last Post: May 19th, 2003, 09:57 PM
  5. Creating Access DB - multiple value concerns, etc.
    By Tekime in forum Database Management
    Replies: 8
    Last Post: February 24th, 2003, 11:03 AM

IMN logo majestic logo threadwatch logo seochat tools logo