I am implementing a tag cloud system based on this recommendation. (However, I am not using foreign keys)I am allowing up to 25 tags. My question is, how can I handle editing on the items? I have this item adding/editing page:Title
escription:Tags: (example data) computer, book, web, designIf someone edits an item details, do I need to delete all the tags from Item2Tag table first, then add the new elements? For instance, someone changed the data to this:Tags: (example data) computer, book, web, newspaperDo I need to delete all the tags from Item2Tag table, and then add these elements? It seems inefficient, but I could find a more efficient way.The other problem is with this way is, if someone edits description but does not change the tags box, I still need to delete all the elements from Item2Tag table and add the same element.I am not an experienced PHP coder, so could you suggest a better way to handle this? (pure PHP/MySQL solution is preferable) Thanks in advance,
escription:Tags: (example data) computer, book, web, designIf someone edits an item details, do I need to delete all the tags from Item2Tag table first, then add the new elements? For instance, someone changed the data to this:Tags: (example data) computer, book, web, newspaperDo I need to delete all the tags from Item2Tag table, and then add these elements? It seems inefficient, but I could find a more efficient way.The other problem is with this way is, if someone edits description but does not change the tags box, I still need to delete all the elements from Item2Tag table and add the same element.I am not an experienced PHP coder, so could you suggest a better way to handle this? (pure PHP/MySQL solution is preferable) Thanks in advance,