Remove duplicate entries from views results... the hard way.

In some cases it is seems impossible to get rid of the duplicate entries that views return in the output.
Not an elegant way, but this small module would do the trick...

So let's create a module the usual way, and put the following code in the .module file.
This one is called remove_duplicates.


<?php
function <MY_MODULE>_views_pre_render(&$view)
{
 
$used_nids = array();

          foreach (
$view->result as $row)
      {
        if (!
in_array($row->nid, $used_nids))
        {
         
$new_view_result[] = $row;
         
$used_nids[] = $row->nid;
        }
      }
  
     
$view->result = $new_view_result;
    }
?>

Tags: 
Drupal 6, Drupal 7, Drupal Quick Tips, Views

Recent Comments

Forward by Dries Buytaert, Founder and Project Lead, Drupal; CTO Acquia.

Order now from:

Managing Expectations Podcast with DrupalEasy

Author Interview http://tinyurl.com/8a8nxno

We provide the most Shiny Drupal Bits & Pixels

Since Drupal 4.x