Hi to all,
i am building a site with movie reviews.. due to the
fact that a movie may have more than one category ex
action, adventure, sci fi etc i ended up using a sinlge
column to add all tha categories in comma delimited
form..
1st question.
is the structure wrong? do i have to alter the table
each time the user add a new category and store any
category as a individual column?
2nd question.
how can i find similar movies order by the most common
values?
ex
i have a action,fantasy movie
and then movies with
action,adventure,horror
adventure,fantasy
adventure,fantasy,action,horror
adventure,horror
i want to pick the first 3 with order 3,2,1 or 3,1,2