PHP/MySQL - Similar Matches (Like Digg's Similar Stories)

Discussion in 'PHP' started by Galaxian, Jan 9, 2011.

0
  1. #1
    The best way to explain this is with a familiar example:

    On Digg, when you submit a new article, it shows potential duplicates of what you're posting.

    I'd like to create a similar feature on my website to help reduce duplicate submissions, but not so duplicate that they're word for word, there could be extra grammar or different words with the same meaning.

    Is there anyway to do this with PHP/MySQL?
     
    Galaxian, Jan 9, 2011 IP
  2. ssmm987

    ssmm987 Member

    Messages:
    180
    Likes Received:
    4
    Best Answers:
    3
    Trophy Points:
    43
    #2
    Use Mysql's fulltext search function, it returns a percentage which indicates how much the new entry match each of the existing entries.
     
    ssmm987, Jan 9, 2011 IP
  3. ankit_frenz

    ankit_frenz Active Member

    Messages:
    1,111
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    63
    #3
    also while matching you can ignore useless keywords like "is" ,the,a ,an etc
     
    ankit_frenz, Jan 9, 2011 IP