Pull rows from a table that match a column in a row in another table

PHP
1

Hopefully the subject/summary makes sense of what I’m trying to do.

In Table ‘category’ I have a 6 column table. The first column is a category name and the 2nd - 6th columns are spaces for products related to that category (although not all 6 columns are always full).

In Table ‘products’ I have a list of every product with some defining features.

What I want to do is pull all of the products from Table ‘products’ that are in a particular row in Table ‘category’ that matches a category I specify. I’m beating myself over it because it seems easy to join the tables but I’m getting mixed up on combining columns and rows.

Thanks!

2

if you have something like this:

tblCategory

fldCatId
fldCatName
.
.
.

tblProducts

fldProdId
fldCatId
.
.
.

then it should be straight forward getting all the products in a particular category by joining the tables on fldCatId

3

Ah…yes that’s an important part I left out. Doh!

Products can belong to multiple categories so in that example with tblProducts there is no fldCatId to join.

4

Then you need a third table with tblProdId and tblCatId that has a row for each category a product belongs to.