ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Display the second most recent blog entry, third most recent, etc.

January 08, 2009 3:58pm

Subscribe [2]
  • #1 / Jan 08, 2009 3:58pm

    hofboone

    12 posts

    I’d like to display the 2nd most recent blog entry (by date of entry), and the 3rd most, etc… I understand I can pull the headlines fo the last X amount of entries. I’m not looking for that.  What I am trying to do is have a tabbed navigation in the heart of my page where the first tab will show the most recent blog entry title, blurb, photo, etc., the second tab will show the 2nd most recent entry, and so on.  So it performs as a rotating tabbed nav of the most recent stories.

    Has anyone done this?

    Thanks

  • #2 / Jan 08, 2009 4:04pm

    Ingmar

    29245 posts

    Couldn’t you simply use

    offset="1"

    in your tag?

  • #3 / Jan 08, 2009 4:17pm

    hofboone

    12 posts

    Thanks, I’ve looked at that and, unfortunately, because I am building a site that is complex and requires me to connect to another DB in addition to the EE DB, I can’t use EE tags on that page.

    It’s been suggested to me that I take the data in the other DB and move it to the EE DB, so I’m only querying one DB.  However, that goes against much of what I have been taught about optimizing DB’s.  Anyone have any suggestions on that topic?

  • #4 / Jan 08, 2009 4:21pm

    Ingmar

    29245 posts

    Yes, I’d defnitely suggest to keep it to a single database. Either way, there is an OFFSET parameter in raw SQL as well, so you might want to look into that.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases