I made a custom admin panel for a news website. The administrator can select many "position" when he choose where to publish. I'm using PHP and MySQL.
After that, I have to SELECT based on one "position" (every one "position" represents a container of news in the web site. Note that a news can be in many "position").
My question is: Which should be the best way to store the position?
I have considered:
Any ideas?
Finally, I used an extra table with 3 columns: "id news position" with foreign key "news position".