Dear friend, I am classifying some items. The items will be stored in a large MySQL database (probably InnoDB engine). At storage time, we would like to append a series of descriptive categories to the item, in order to facilitate "friendly", very flexible searches later.
For instance item A is in main category food, subcategory organic, sub-subcategory vegetarian. Item B is category organic, sub-category food, sub-sub category baby. As you see the same category can be main category for one type of item, subcategory for another item, sub-subcategory for another. I have been working on this thing for a couple of days now, but I have not been able to come out with any clever solution. I need - good efficiency on multicategory searches - to store data in a relational table (if possible) - to update easily the list of categories (the table) - to address the problem of assigning a different status (main, sub, sub-sub and so on) depending on the type of item to each category I put in the list. Help! -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]