Arcanius Style Recent Comments

Album Cover: It's Not Me, It's You

"I'm not a saint, but I'm not a sinner...everything's cool as long as I'm getting thinner."
Lily Allen / The Fear

Posted on December 09, 2005 12:52 AM in Web Development
Warning: This blog entry was written two or more years ago. Therefore, it may contain broken links, out-dated or misleading content, or information that is just plain wrong. Please read on with caution.

I would have called them "Bernzilla Comments," but apparently the name was already taken. If you aren't reading this in a newsreader, you might have noticed that I've updated the way recent comments are displayed in the subheader of my site. The inspiration came, appropriately enough, from a recent comment by Ryan (aka Arcanius). We seem to have inspired each other, albeit in slightly different ways, so I think everyone wins in the long run.

Because of MySQL limitations like the one Ryan discussed and others, adding the new functionality wasn't as easy as it probably should have been. Going down the whole SELECT DISTINCT path didn't do much good either. MySQL does some funky things when you use DISTINCT in table joins or when returning several pieces of data. That is another subject for another time, though.

If anyone's particularly interested in how I implemented this, I might be willing to go into more detail. Because my blog is "home brewed" and I don't use a publicly available system like WordPress, the specifics of my code might not be as useful as posting pseudo code, but I'm willing to do either. In the meantime I'll just say that I wrote a custom PHP function to do the job.

I'm still debating whether I should report a count (in parentheses) when there has been only one recent comment for a post, or whether I should include the x as suggested by Ryan. I'd love to hear any and all feedback, so either leave a comment or send me an email.

Comments

Ryan on December 11, 2005 at 7:08 AM:

I notice that clicking on the recent comment link takes me to the last of the (x) comments, whereas I would expect it to take me to the first of the (x) comments.

Otherwise, I would be interested in the pseudocode at least, to see how much you relied on SQL and how much was processes in PHP afterwards, and how you did that, exactly.

Permalink

Ryan on December 11, 2005 at 7:08 AM:

Other than that one nitpick, it looks great and I think adds much to the usability of the site!

Permalink

Ryan on January 23, 2006 at 10:01 PM:

With how popular your site has become as of late, you may need to have more than three (3) recent comments up there! I came back to check and in just a few hours I've noticed that the entire list of comments that had been up before had scrolled off. Of course I'm probabally not helping, as this is my third comment (I think) tonight.

Permalink

Bernie Zimmermann on January 24, 2006 at 12:26 AM:

Or perhaps it's time for a Recent Comments feed. Hmm...

Permalink

Accounting Assignment Help on February 02, 2018 at 3:52 AM:

John arnold is an academic writer of the Dissertation-Guidance. Who writes quality academic papers for students to help them in accomplishing their goals.

Permalink

Accounting Assignment Help on February 02, 2018 at 3:53 AM:

Great Information,it has lot for stuff which is informative.I will share the post with my friends.

Permalink

Project Management Assignment Help on February 02, 2018 at 4:33 AM:

I personally like your post, you have shared good article. It will help me in great deal.

Permalink

Project Management Assignment Help on February 02, 2018 at 4:34 AM:

This is really great work. Thank you for sharing such a useful information here in the blog.

Permalink

http://www.theoriginalhcgdrops.com/ on March 10, 2018 at 9:37 AM:

Thanks for the post and great tips..even I also think that hard work is the most important aspect of getting success

Permalink

Post Comments

If you feel like commenting on the above item, use the form below. Your email address will be used for personal contact reasons only, and will not be shown on this website.

Name:

Email Address:

Website:

Comments:

Check this box if you hate spam.