Solved

drupal - auto-generate and display contextually related links based on content

Posted on 2010-08-25
5
469 Views
Last Modified: 2012-06-22
Hi, I was wondering if there is any drupal module that will scan our site articles, and automatically suggest contextually relevant links based on the content of the articles.

something similar to the links below:

http://relatedlinks.googlelabs.com/

http://mitcho.com/code/yarpp/ (wordpress)

http://ajaydsouza.com/wordpress/plugins/contextual-related-posts (wordpress)

http://www.searchenginejournal.com/3-ways-to-display-related-posts-in-wordpress-blog/17213/

http://www.surphace.com/ 

0
Comment
Question by:darkbluegr
  • 3
5 Comments
 

Author Comment

by:darkbluegr
ID: 33523867
0
 
LVL 16

Assisted Solution

by:HagayMandel
HagayMandel earned 200 total points
ID: 33532251
It seems that the best and most simple way to it is to use the search_index table from the database.
The select statement is:
SELECT 'sid' FROM  `search_index`
ORDER BY  `score`DESC ,`word` DESC
LIMIT 0 , 30
(Where LIMIT limits the number of results).
The sid actually is the nid or vid in the node_revisions table.

You can use the otput (array of sid) to generate a select call to the node_revisions table, and generate links to the actual nodes accordingly.

After that, the
0
 

Author Comment

by:darkbluegr
ID: 33549250
Thank you - can you please repost your answer as it was truncated for some reason
0
 

Accepted Solution

by:
ellyjonez earned 300 total points
ID: 33563815
If you use the ApacheSolr search module, it comes with an excellent "related content" block that uses search. It's also a generally better Drupal search.

http://drupal.org/project/apachesolr
0
 

Author Closing Comment

by:darkbluegr
ID: 33658861
thanks for the interesting info
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now