By Anonymous (not verified) on

Hi !

I have this code somebody gave me a long time ago to display the X last nodes - 1. It means it should display for eg. the last 5 teasers of the last 5 published nodes except the very last one wich will be displayed somewhere else on the website.

It could be cool but the code doesn't work in my Drupal 4.7.

Can somebody help me please ?

Thanks a lot ;)

<?php
/**
* This php snippet displays content of a specified type, with teasers,
* from certain taxonomy term.
* Sorted by date of creation, most recent first.
* Works with nodes of the flexinode type too.
* To change the length of the list, change $listlength.
* To change the taxomony term, change $taxo_id.
* To change the type of content listed, change the $content_type.
* Tested with Drupal 4.6.3
*/
  $listlength="5";
  $taxo_id = 1;
  $content_type = 'story';
  $count = 0;
  $result1 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n INNER JOIN term_node ON n.nid = term_node.nid WHERE n.type = '$content_type' AND term_node.tid = $taxo_id AND n.status = 1 ORDER BY n.created DESC"), $listlength);
  while ($node = db_fetch_object($result1)) {
    if($count > 0)
    {
      $output .= node_view(node_load(array('nid' => $node->nid)), 1);
    }
  }
print $output;
?>
⋅ Categories: Drupal 4.7.x

Comments

Anonymous’s picture

Anonymous (not verified) commented

In fact it means that I want to display the LAST BUT ONE NODES ;)

Maybe it's clearer. I really need your help ;)

nevets’s picture

nevets commented

While you could make a simplier change (there is no incrementing of $count) I also updated the snippet to be more "Drupalized". I also change pager_query to db_query_range which is the more approriate function and added the ability to specify how many records to skip. Also $liistlength is now the number of nodes to display. The call to node_load() was updated to use the simplier interface when the only thing passed is the nid.

<?php
/**
* This php snippet displays content of a specified type, with teasers,
* from certain taxonomy term.
* Sorted by date of creation, most recent first.
* Works with nodes of the flexinode type too.
* To change the length of the list, change $listlength.
* To change the number of initial records skipped change $skip_first_n
* To change the taxomony term, change $taxo_id.
* To change the type of content listed, change the $content_type.
* Tested with Drupal 4.7
*/
  $listlength= 5;
  $skip_first_n = 1;
  $taxo_id = 1;
  $content_type = 'story';
  $count = 0;
  $sql = "SELECT n.nid, n.created FROM {node} n INNER JOIN term_node ON n.nid = term_node.nid WHERE n.type = '%s' AND term_node.tid = %d AND n.status = 1 ORDER BY n.created DESC";
  $sql = db_rewrite_sql($sql);
  $result1 = db_query_range($sql, $content_type, $taxo_id, $skip_first_n, $listlength);
  while ($node = db_fetch_object($result1)) {
  	$output .= node_view(node_load($node->nid), TRUE);
  }
print $output;
?>

On my windows box, n.type = '%s' needs to be coded as n.type LIKE '%%%s%%' to work.

Anonymous’s picture

Anonymous (not verified) commented

Hi Nevets,

You did a really great job !

I'm sure it will help every Drupal user who wants to have a kind a Newspaper layout.

Thanks a lot, it works perfectly :)

Matt

Anonymous’s picture

Anonymous (not verified) commented

HI!
I've a problem with this code.
For some reasons, I've edited my flexinodes and suddely, each teaser's displayed twice on my page...

I really don't know what can happen :-/ It's amazing.

Do you have an idea ?

Thank you.

nevets’s picture

nevets commented

Try changing

SELECT n.nid, n.created

to

SELECT DISTINCT(n.nid)

The n.created was not used/needed and the DISTINCT will make sure each nid is only returned once. (The existing code will return the nid once for each term is uses)

Anonymous’s picture

Anonymous (not verified) commented

Perfect !

Thanks Nevets :)

Anonymous’s picture

Anonymous (not verified) commented

my comment was an error, forget it, sorry.

Anonymous’s picture

Anonymous (not verified) commented

Hello,

I don't know why this doesn't work with "blog" content type...
do you ?

DrupalDummy-1’s picture

DrupalDummy-1 commented

Thank you. This code works in 5 also and I find it very useful.

I would like to split $output into

Print $title
Print $author
Print $date
Print $teaser
Print $links (readmore)

I want to do this in order to have control over location of the variable.

How do I do that? Thanks again for the useful code.

nevets’s picture

nevets commented

Views would be useful for that.