This may be too specific, but I'm stumped for a solution.
On my website, I've got lots and lots of articles and recaps. Many of them interconnect to each other (in mostly obvious ways), and while I have manual ways to illustrate the connections (by creating indexes by show, by author, or by promotion), all that work is manual entry on my part, and subject to me screwing up links. And if I could free myself from having to do easily automated tasks, it'd save me time for other things.
I'd like a program that'd automatically index my articles by whatever categories I give them, and allow me to insert those indexes (or portions of them) into my articles. For instance, someone reading a ROH recap by Joe Gagne would get links to the following ROH recaps, and the next five articles Joe did.
I guess I need for a document organizer, as opposed to a manager? I just don't know if such a thing exists. My hosting provider offers what it calls 'Content Manager' programs it can autoinstall for me - but they're more Portals/Blogs like Geeklog and more overpowering than what I’m looking for. I'd really prefer something which I can bend into working with my current setup (or bend my current setup into working with it) rather than something remodeling everything.
It seems easy and obvious, and I think I could do it if I had a week to pick up mySQL, but I haven't in the months I've been thinking this over.
(The system The X-Axis uses to connect it's comic reviews - look on the left sidebar - is what inspired this idea in me, and what I'm looking to emulate.)