Welcome to HBH! If you had an account on hellboundhacker.org you will need to reset your password using the Lost Password system before you will be able to login.
Question on how to create my SQL table
I am making a website which will categorize articles. The problem is that I want an article to be able to be part of multiple categories.
For example, "tomato" needs to be part of
"foods -> vegetables -> tomato"
and also
"things to throw -> soft -> tomato"
If I had only one category per article, the table design would be easy - a column for categoryID and no problem.
But what about these multiple categories?
I need to be able to list all the articles in a category, so I cannot merely store the categories for an article as an array (unless I use "LIKE" with some delimiters, I guess, but that sounds ugly.)
Ideas? I'm sure someone here has run into this problem before.