By anonymouscowards on

This is related to the question I posted here: http://drupal.org/node/150323

How can I get a view to return not the last three blog entries, but the second last three entries... errr I mean the last four entries minus the most recent entry.... the last three starting from the second entry...?!?! Am I making any sense at all?!

If someone does understand what I'm talking about I'd be really grateful for some help! Have been abusing google and drupal search for the past couple of hours to no avail on this one... :(

⋅ Categories: Drupal 5.x

Comments

anonymouscowards’s picture

anonymouscowards commented 
<?php
$num_nodes = 3;

$result = db_query_range(db_rewrite_sql('SELECT n.nid, n.title, n.type
FROM {node} n
WHERE n.status = 1 AND n.type = "blog"
ORDER BY n.created DESC'), 1, $num_nodes);

$output = node_title_list($result);

print $output;
?>

where "blog" is the name of my blog content type and the "1" in "ORDER BY n.created DESC'), 1, $num_nodes); is the offset that returns the query from the second result onwards.

If anyone can tell me how to do this with views, or if there is a better way I'd be grateful!