Return to Snippet

Revision: 7930
at August 21, 2008 10:31 by aleprieto


Initial Code
<?php
if (arg(0) == 'node' && is_numeric(arg(1)) && is_null(arg(2))) {
  $nid = (int)arg(1);
  $terms = taxonomy_node_get_terms($nid);
  $output = "<ul>";
  foreach($terms as $term){
    $sql = "SELECT DISTINCT n.title, n.nid FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE n.status = 1 AND tn.tid = $term->tid AND n.nid != $nid AND n.type <> 'image' ORDER BY n.created DESC LIMIT 6";
    $result = db_query(db_rewrite_sql($sql));
    if (db_num_rows($result)) {
      while ($anode = db_fetch_object($result)) {
        $output = node_title_list($result);
      }
    }
  }
  return $output;
}
?>

Initial URL


Initial Description
Here is a simpler list format without the Term name, sorted by date, filtered for published and images, and is rendered correctly by the theme.

Initial Title
Related nodes to the current node by taxonomy term (2)

Initial Tags
module, drupal

Initial Language
PHP