Hi,

Using the blog module is it possible to stream particular posts to another page such as the second only or third post. The following code is for selecting the first posts depending on descending order, but I only want to choose say the second post. Is there any way to do this? any help is much appreciated.

function LatestBlogPosts($num=2) {
$news = DataObject::get_one("BlogHolder");
return ($news) ? DataObject::get("BlogEntry", "ParentID = $news->ID", "Date DESC", "", $num) : false;
}

Hi Shluckey,

If you're still looking for an answer to this you could use the following to get 2nd post.

function LatestBlogPosts() { 
$news = DataObject::get_one("BlogHolder"); 
return ($news) ? DataObject::get("BlogEntry", "ParentID = $news->ID", "Date DESC", "", "2,1") : false; 
}

Using "2,1" in the limit clause tells MySQL to return one record at the second position. So to get the third item you would use "3,1".

Hope this helps.

Thanking you so much!