Multiple Products Having multiple categories
I have following tables: Products & Categories
Products contains: ID, Name, CatID and etc...
Categories contains: ID, Name
Lets say product 'x' have multiple CatID & are stored 1,2,3.4.......
If i want to display products of CatID 3 it doesn't display. But product which has CatID as 3 only displays.
Why is it not capturing '3' CatID for product 'x' as mentioned above.
So then product 'z' has only 1 CatID as : '3' This doesnt display the product.
Why not x?