SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    PHP Guru's Avatar
    Join Date
    Jan 2009
    0 Post(s)
    0 Thread(s)

    How to find similar threads?

    Just wondering, what is the common way to find 'similar' forum threads (for example).

    Just like on this vbulleting forum and on many other forums many threads contain links to 'similar threads'.

    How are the 'similar' items found - based on only the title of the thread or using the fulltext index of the body of posts?

    Can someone explain this to me, no php code is necessary, I can write my own as long as I know the steps involved? I mean , do you first break up the title into individual words, then find threads with titles that contain these words? Do you use any type of 'stop words' to filter our common words like 'they, this, the', etc...
    My project: Open source Q&A
    (similar to StackOverflow)
    powered by php+MongoDB
    Source on github, collaborators welcome!

  2. #2
    SitePoint Evangelist Waffles's Avatar
    Join Date
    Nov 2005
    0 Post(s)
    0 Thread(s)
    extensive abuse of the SQL LIKE '%Foo'% function

    tags - i.e give the option for users to tag their posts with key words, "php", "css", "html"

    search for similar threads with those key words.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts