Hi,

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: Description: Tags: (example data) computer, book, web, design

If 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, newspaper

Do 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,