How can I do this with CodeIgniter

[eluser]egy_programozo[/eluser]
rip_pit's code v1.2

Code:

$this->db->select('blog.*, categories.id as category_id, categories.name as categories_name');
$this->db->from( 'blog' );
$this->db->join( 'categories', 'categories.id = blog.cat_id', 'LEFT');
$this->db->order_by('categories.name ','DESC');
$this->db->order_by('blog.id','DESC');
$query = $this->db->get();

if ($query->num_rows() > 0)
{
  $results = $query->result();
  
  //do what filtering is needed
  $memory = false;
  foreach ($results as $key => $row) {
    if ( $row->categories_name != $memory ){
        $memory = $row->categories_name;
        echo $mermory.'<br>';
    }
    echo ' -> '.$row->name.'<br>';
  }

}
else
{
  echo 'nothing to do here...';
}