'Mysql table scheme for featured / emphasized products
Well my problem is that I would like to store some kind of products in their own tables and from these products I would like to select some into a featured / emphasised products table which would store the ID of the selected rows from each table to display those featured products on the home page of a website.
After selecting the featured products from their tables I would like to make my own order how they will be listed, so I think a new table is needed where I can store the ID and the order of the featured products, but I can't imagine how to connect these tables properly.
I was thinking a lot how to solve this problem but, I hope somebody will know the correct answer!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|