related tags

A related tags list is now showing at the top of tag rooms. 

In addition the tag heirachy of the tag room are starting to show as well. 

It is not totally working.  There are more related tags showing than there shoul be and sometimes the tags are shown multiple times.   As you click another tag into the tag herachy, you should narrow the number of related tags; however you do not, you increase the number of related tags.  

The SQL retrieval is:

  SELECT t.id, t.tag, m.id, m.tag
  FROM  taggings AS t , taggings AS m
  WHERE  m.id = t.id
  AND t.tag IN (%s)
  AND m.tag NOT IN (%s)
  ORDER BY m.tag

where the tags list in the URL of the tab room is substituted for %s. 

Now from that result list we need to exclude all tagging that do not have all the tags in the taglist. 

I think i got this working in a reasonable manner.   The algorithm is her

Note that the beet goes on in tag display and navigation project


Tags

  1. related tags
  2. new features
  3. programming
  4. _tags
  5. algorithms
  6. sql

See Also

  1. Thought Announcement: more file type uploads with 43 viewings related by tag "new features".
  2. Thought Footer problem on individual page at speaktomecatalog.com with 19 viewings related by tag "programming".
  3. Thought Do we need system tags? with 18 viewings related by tag "_tags".
  4. Thought Linking fastblogit tags to other sites with 4 viewings related by tag "new features".
  5. Thought Chat Who's Here with 3 viewings related by tag "new features".
  6. Thought What are related tags? with 1 viewings related by tag "related tags".
  7. Thought related obscene tags with 1 viewings related by tag "_tags".
  8. Thought control for ~ (censor tags not converted) with 1 viewings related by tag "_tags".
  9. Thought The cartoon clone button has been deactivated in some cases. with 1 viewings related by tag "new features".
  10. Thought about: try ruby! (in your browser) with 1 viewings related by tag "programming".
  11. Thought test of tags with blank in front of word with 1 viewings related by tag "_tags".
  12. Thought new feature: about with 1 viewings related by tag "new features".
  13. Thought you now can embed Num Sum spreadsheets in items with 1 viewings related by tag "new features".
  14. Thought SQL for selecting triples inside of one field. with 1 viewings related by tag "programming".
  15. Thought some thoughts on trans domain data transfer with 1 viewings related by tag "programming".
  16. Thought Please fix bad tags with 1 viewings related by tag "_tags".
  17. Thought a good place to satisfy question~answer with 0 viewings related by tag "programming".
  18. Thought news now refreshes every 2 seconds and shows ads with 0 viewings related by tag "new features".
  19. Thought Wiki Reference Wish List with 0 viewings related by tag "new features".
  20. Thought Now you can delete your unwanted items with 0 viewings related by tag "new features".
  21. Thought automatically update all taggings at del.icio.us with 0 viewings related by tag "_tags".
  22. Thought sources of php code with 0 viewings related by tag "programming".
  23. Thought What is a tag ? with 0 viewings related by tag "_tags".
  24. Thought about: Then each went to his own home with 0 viewings related by tag "programming".
  25. Thought Removal of tag index from river with 0 viewings related by tag "new features".
  26. Thought sql explained for group tagroom with 0 viewings related by tag "programming".
  27. Thought deactivate HTML in comments - or how and where to escape with 0 viewings related by tag "programming".
  28. Thought propogate logic from front door to rooms and refactor with 0 viewings related by tag "programming".
  29. Thought Ok ... so we can do rich text editing ... with 0 viewings related by tag "new features".
  30. Thought Do others define related tags like I do ? with 0 viewings related by tag "related tags".
  31. Thought Announcing: new wiki reference [permalink 1000] with 0 viewings related by tag "new features".
  32. Thought the feed icon shows in the navigation panel of rooms that have feeds with 0 viewings related by tag "new features".
  33. Thought splogs with 0 viewings related by tag "new features".
  34. Thought rich text edit on comments with 0 viewings related by tag "new features".
  35. Thought Related tags don't works in groups ? with 0 viewings related by tag "related tags".
  36. Thought changing the picture size algorithm with 0 viewings related by tag "algorithms".
  37. Thought ok here is the sizing algorithm that will go into testing with 0 viewings related by tag "algorithms".
  38. Thought threshold established for showing tag index with 0 viewings related by tag "new features".
  39. Thought cleaning up tags with 0 viewings related by tag "_tags".
  40. Thought about: Technorati: Mini with 0 viewings related by tag "_tags".
  41. Thought Promotions in the Speak To Me Catalog Shopping Basket with 0 viewings related by tag "programming".
  42. Thought Announcing The Funny Pages with 0 viewings related by tag "new features".
  43. Thought a method of providing for private tags with 0 viewings related by tag "_tags".
  44. Thought Private items have been partually implemented with 0 viewings related by tag "new features".
  45. Thought automatic tags for tagroom with 0 viewings related by tag "_tags".
  46. Thought The Header of the Common Streame can be easily changed with 0 viewings related by tag "new features".
  47. Thought winnies complaint with 0 viewings related by tag "_tags".
  48. Thought study of del.icio.us tag navigation with 0 viewings related by tag "_tags".
  49. Thought comparison between del.icio.us tag navigation and fastblogit with 0 viewings related by tag "_tags".
  50. Thought I wanted to see ... with 0 viewings related by tag "new features".