Advanced Search

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