Related Entries from within my own MT database is something else I’m interested in adding to my weblog soon.
From Delicious
»
»
»
If you’re reading this site via RSS, I apologize for the multiple postings of my “daily links”. I saw the bug earlier this week and through it’d fix itself, but it hasn’t.
I just made a few changes to the site code to try and shut down the errant postings… The problem is I’m not 100% sure where the postings are coming from, so hopefully, I’ve squashed the bug. If not, I’ll try something different tomorrow.
»
Hey John,
Just download b2++ and you’ll have both highlighted searches and related articles!
Demos:
Related articles
Search highlights
Donncha.
PS. sorry for this completely self-promotional comment!
I do related entries over at MobileTracker–it works out well. The only problem is when I make a new category it looks really lame for the first post (no related articles).
have you had any luck migrating a newly created blog to a previous set of archives? the mint400 is going through this issue now. BTW nice site.
On migrating archives – b2 has several scripts for doing such a job.
I used the Blogger one to suck all the data from http://xeer.blogspot.com/ to http://blogs.linux.ie/xeer/. Not sure if there’s an MT one though.
I have an MT plugin that does related entries by keyword or by category. See Related Entries for more details.
I’ve been working with some MySQL fulltext queries for a client recently and like Simon thought it would be interesting to try automatically classifying related articles through fulltext searches. After some experiments last week, I stopped using my own plugin and now generate related entries through a SQL query using Brad’s SQL plugin.
The template code I use on my individual archive pages is…
<MTSQLEntries query=”SELECT entry_id, MATCH (entry_keywords, entry_title, entry_excerpt) AGAINST (‘[MTEntryKeywords encode_php='q'] [MTEntryTitle encode_php='q']‘) AS score FROM mt_entry WHERE MATCH (entry_keywords, entry_title, entry_excerpt) AGAINST (‘[MTEntryKeywords encode_php='q'] [MTEntryTitle encode_php='q']‘) AND entry_id != ‘[MTEntryID]‘ AND entry_blog_id = [MTBlogID] ORDER BY score DESC LIMIT 0 , 4″>
<li><a href=”<MTEntryLink>”><MTEntryTitle></a></li>
</MTSQLEntries>
This avoids database timeouts or other issues, because the related entries are not generated with each page request. Instead, they are calculated only when the page is rebuilt.
It’s been pointed out to me that you need to create the fulltext indexes before that code will work. On my site I have a much more thorough explanation of the technique, including all the steps you need to follow to get it working.
Read Related Entries Revisted for more details.
Thanks Adam!