I am trying to create my first dynamic site in MySQL. It is a site which contains links to various websites that will be listed by appropriate categories.
The question is... How do I need to structure the tables so that I can create a relationship which allows for one site to be listed under multiple categories (which are chosen from another table of available categories)?
Do I need three tables, or just two and what fields need to relate to each other to make this work most efficiently?
Start Free Trial
