|
|
hey David,
I am working on a forum myself and want to implement a "similar thread" feauture. I am not sure, if you know this, but many forums shows a list of threads at the bottom of the posts and show threads that similar like the current one. ie: http://www.geekstogo.com/forum/Similar_Threads-t11235.html I am interested to know how this can be achieved. Can you help me out once again?
Thanks
|
|
|
|
Hello Vishal,
Sure, let me see if I can lend some advice, at least at a high level. One way to find similar threads is to search against the database to match the words that are found in the original post. Since the post is likely to be rather lengthy, I would recommend using the title as your "Search Key". Naturally, you will want to eliminate insignificant words like "and" "or" "to" "this", etc. For example, if the post title is "Switching to RSS Bandit", you will want to search for only the records that have posts containing "Switching", "RSS" or "Bandit", to return similar records. Maybe you will want to limit it to the top "X" records. That is a description of the approach at a high level. Why don't you let me know what you think so far and we can work to refine it if it seems like an approach that you want to use.
Kindest regards,
David Silverlight
HeadGeek@XMLPitstop.com
|
|
|
|
Hey David,
many thanks for the quick reply - though my reply to your reply is a bit late :) Your approach sounds certainly interesting and would like to implement it that way.
For the insignificant words, how would you store them? In a sql table - XML file? I think a SQL table, would be the best, but I would like to hear your oppinion. I wrote a quick SQL, but it returns over 200 rows, and I am not even sure, if I am doing it the correct way:
SELECT * FROM t Where Post LIKE '%switching%' OR Post LIKE '%rss%' OR Post LIKE '%bandit%'
Does that look good?
Thanks for your support.
|
|
|
|
|
|