Related nodes to the current node by taxonomy term (1)


/ Published in: PHP
Save to your folder(s)

Use the code below to build a custom block that shows the related nodes to the current node by taxonomy term. For example: If the current node in display has a taxonomy term "fish", a bunch of links that link to nodes that have the "fish" term is to be shown in a block on the page.


Copy this code and paste it in your HTML
  1. <?php
  2. if (arg(0) == 'node' && is_numeric(arg(1)) && is_null(arg(2))) {
  3. $nid = (int)arg(1);
  4. $terms = taxonomy_node_get_terms($nid);
  5. $output = "<ul>";
  6. foreach($terms as $term){
  7. $sql = "SELECT n.title, n.nid FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid = $term->tid AND n.nid != $nid LIMIT 5";
  8. $result = db_query(db_rewrite_sql($sql));
  9. if (db_num_rows($result)) {
  10. $output .="<li>$term->name</li><ul>";
  11. while ($anode = db_fetch_object($result)) {
  12. $output .= "<li>".l($anode->title, "node/$anode->nid")."</li>";
  13. }
  14. $output.="</ul>";
  15. }
  16. }
  17. $output .= "</ul>";
  18. return $output;
  19. }
  20. ?>

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.