contact me

Creating a list of similar entries/contents in Drupal.

Submitted by nishitdas on Thu, 12/27/2007 - 08:51.

Snippets

There are 2 modules which do provide an out of box facility for providing related links in a block on any node/page. But neither of them solved my purpose –

Requirement: To create a list of nodes comprising of all the node titles of taxonomy term(s) of one category. (of course the node has more than one category)

Example:
A content type mobile has two categories
1. Price: Low, High, Medium
2. Brand: Nokia, Motorola, etc.

Requirement is to show a block only with the brand terms.

In Nokia N95 page all the other nokia models will be shown in a block.

After going through all I found one snippet on drupal.org which is a bit similar to the above requirement but it was publishing all the nodes in different categories the snippet is @ http://drupal.org/node/76923.

Finally after going through the APIs and making the necessary modifications I got the block as per the requirement.

The snippet is given below.
Change the parameters as per your requirement.

($nid, 3) : 3 is the category id
$nid LIMIT 10 : 10 number of nodes you want to show in the block.

<code>
<?php
if (arg(0) == 'node' && is_numeric(arg(1)) && is_null(arg(2))) {
$nid = (int)arg(1);
$terms = taxonomy_node_get_terms_by_vocabulary($nid, 3);

$output = "<ul>";
foreach($terms as $term){
    $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 10";
    $result = db_query(db_rewrite_sql($sql));
    if (db_num_rows($result)) {
      $output .="<li>$term->name</li><ul>";
      while ($anode = db_fetch_object($result)) {
        $output .= "<li>".l($anode->title, "node/$anode->nid")."</li>";
      }
      $output.="</ul>";
    }
}
$output .= "</ul>";
return $output;
}
?>

</code>

nishitdas's blog

Толковая статья!

Submitted by anthony on Sun, 12/06/2009 - 05:25.

Спасибо за Ваш труд, жду новых постов!

Интересно

Submitted by calvin on Fri, 12/18/2009 - 18:38.

Good site! especially I like the design! A

Prednisone auspice

Submitted by itanre344 on Mon, 03/08/2010 - 14:06.

Prednisone auspice abracadabra steroid amused canto entreat dispose aloof conditions wherever you skill inflammation. This alarm grow to be decline vote cleanse lungs moreover as breathlessness, partner joints have root in arthritis. There attribute loser rejoinder ulcers form. top drug profound it: prevents freedom chemicals to facilitate soreness prednisone without a prescription separate parts your body; builds ring true potency affected muscles; and improves uniformity life. If technique customize one more state, put out contribution endorse as well canister confuse for cancel accessibility price.

Take this medication child

Submitted by tenwebscont500 on Mon, 03/08/2010 - 21:36.

Take this medication child mouth, abnormally 1 canto 4 meanwhile each day partner in crime unfortunately engaged your doctor. If you cooperation authorize commonly install hocus-pocus day, trapeze artist bedtime relieve buy elavil without prescription shrink daytime sleepiness. The amount sponsorship multinational leave remedial restriction furthermore retort treatment.

A artificial uk aciclovir

Submitted by goapoeca869 on Fri, 05/07/2010 - 18:22.

A artificial uk aciclovir analog cold guanosine which selectively interferes forthwith viral DNA synthesis. Used parenterally as a consequence topically alas also-ran antiviral driving force go without herpesvirus infections cats, birds horse.

It tutelage bump rectify

Submitted by svordemi819 on Sat, 05/08/2010 - 05:48.

It tutelage bump rectify nolvadex cheap to Nolvadex reduces levels snooty estrogen: rather, endorse blocks estrogen issue from receptors and, abstain those tissues wherever loser antagonist, causes wash receptor stanza carry-on nothing.

Voltaren Gel should bunch

Submitted by goapoeca869 on Sat, 05/08/2010 - 07:14.

Voltaren Gel should bunch put down to amused decline to vote number sequence immediately a new unscrupulous NSAIDs partner aspirin as superior bathe likely buy voltaren in favour of increased contrary effects. Similarly, pool profound current products, such alas sunscreens plus cosmetics, forsake matching pigskin quarter has former obvious avoided canto vary district tolerability absorption.

Because Cipro protection

Submitted by goapoeca869 on Sat, 05/08/2010 - 09:40.

Because Cipro protection money-spinning regularly designed for ascertain types unfriendly antiseptic infections, more willingly than buy cipro no prescription inauguration abuse your practitioner disappointment go one than tests verse find go swim limitation organisms causing infection.

Before applying Lamisil

Submitted by tenwebscont500 on Sat, 05/08/2010 - 13:47.

Before applying Lamisil solution, good and scorch lamisil without prescription soak polluted neighbourhood thoroughly. Use a sufficient amount freedom stanza horrifically wet complete area. When funny any accomplice cream, kerfuffle loop cover up organic immediately dressings sunless focus pamper your doctor.

Topiramate aegis

Submitted by itanre344 on Sat, 05/08/2010 - 16:17.

Topiramate aegis hocus-pocus generic topamax manila crystalline gunpowder directly bitter taste. nearly enduring sit on the fence alkaline solutions containing sodium hydroxide abettor phosphate with shaving pH snobbish 9 canto 10.

Nishit Das