Thread

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

Couldn’t you simply use

offset="1"

in your tag?

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?

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.