|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 25th, 2000, 08: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.
Regards Ian
|
|
#2
August 26th, 2000, 09: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.
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > Multiple Categories |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
