tips and tricks for movable type

lastn recently modified entries using MTSQL
January 19, 2003

I requested an additional attribute to MTEntries - recently_modified=N - to list a limited number of entries based on when they were last updated.

Brenna posted a solution in this support forum thread, which uses Brad Choate's MTSQL plugin.

My slightly modified version:

<MTSQLEntries query="select DISTINCT entry_id from mt_category, mt_placement, mt_entry where (placement_category_id = category_id) and (placement_entry_id = entry_id) and (category_blog_id = 8) and (entry_status = 2) order by entry_modified_on desc limit 5"><a href="<MTEntryLink>"><MTEntryTitle></a> in category: <a href="<MTEntryLink archive_type="Category">"><MTEntryCategory></a><br />
</MTSQLEntries>

Change 8 to your blog's ID number, and change 5 to the number of entries you want to list.

11:42 am | mysql | plugins | tricks | send link

Comments

You can specify [MTBlogID] within the query to automatically use the proper blog id. In fact, you can use any MT tag within the query when it's written with angle brackets like that.

by Brad Choate | 02.04.03 11:03 AM

Hmmm, so if you're displaying in blog 1 entries from blog 8, you could also use [MTOtherBlog blog_id="8"] in there?

Wait, that would be overkill, huh? =)

Thanks for that tip, Brad, Enhances the script even further, because you can then just copy and paste into all your blogs with no changes.

by girlie | 02.04.03 10:18 PM

Thanks, I really needed that info.

by Joe | 05.29.03 06:39 PM

use [MTOtherBlog blog_id="8"]

by conor | 10.18.03 08:06 AM

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

TrackBack: 4
(URL: http://www.thegirliematters.com/sf/mt-track.cgi/132)

» Sideblog "Interesting Links" setup HOWTO
Excerpt: Brad Choate mentions his sideblog idea -- in which he "lists things that I wish to share when I have no time to supply my own witty commentary" -- which in turn came from Anil. Until Brad describes how he set up his sideblog and displays its content i...
Weblog: Tread lightly on the things of earth
Tracked: 02.04.03 05:00 PM

» Bloggie Scripty Reverb
Excerpt: I like to keep an up-to-date listing of all the...
Weblog: Bloggie Broad
Tracked: 12.16.03 06:07 PM

» Bloggie Scripty Reverb
Excerpt: BB's Script, Plugin and Hack Archive as of 3/1/04: Collapse...
Weblog: Bloggie Broad
Tracked: 03.01.04 05:42 PM

» Recent Updated Articles Works
Excerpt: Using a tip from at [the girlie matters] tips and tricks: lastn recently modified entries using mtsql I finally enabled the listing of my most recently updated entries. This is good, because I often go back and change or edit past entries. Now there...
Weblog: Jay Shao
Tracked: 04.13.04 12:19 AM

« limit excerpt to a paragraph | main | creating a comments feed »