Best method to store ordered list?
Posted on 2006-11-05
I'm looking for the optimal method for storing/retirieving a list of items that i allow the user to sort using a php/js/html front end.
I have a "projects" table that is used to store name, dates, abstract, etc for a project. I also need to store information regarding a static list of relevant keywords. For instance a set of 10 keywords, each with a rank chosen by the user. I assume that i should use a m-m type set up with a linking table but am not sure regarding the optimal implementation. Should I create a "keywords" table, populate it with the words, then store the sort information with the linking table?