Kobashi Computing

When creating landing pages, its often best to leave your users with a choice of where to go after they read your content. Under Drupal, the best way to do this is to use the taxonomy module and tag all your content. Then, show all related articles to the content.

By doing so, the user is given a choice to leave the page and exit or navigate further into your site. Here is a Drupal PHP snippet that will list links to related articles for the current node.


function GetRelatedLinks($node, $numNodes=3) {
$output = "";
$terms = taxonomy_node_get_terms($node);
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 != ". $node->nid ." ORDER BY n.created DESC LIMIT $numNodes";
$result = db_query(db_rewrite_sql($sql));
$output .= node_title_list($result);
}
return($output);
}


For instance, lets say that the article for this node was about Drupal and Modules. If you installed the Drupal taxonomy module, this code will grab all the terms associated with the node for each taxonomy category and then walk through all the terms to build a linked list.

So you will see something like this:

• Learning Drupal
• Drupal Hosting
• How To Administrate Drupal

• Installing the Taxonomy Module
• How To Use The Path Module
• Creating New Content With The CCK Module

You can use this as a block, or drop it into your node templates.