Set Posts activ/inactiv

[eluser]Zimooon[/eluser]
Allright thank you that could work.
Now until now i had the view like this:

Code:

<?php if (isset($posts) ) : foreach ($posts as $p):      ?>
          
  
          <h1 id="news">&lt;?php echo $p['title']; ?&gt;</h1>
        
          
          &lt;?php echo $p['content']; ?&gt;
          <br />
          &lt;?php echo $p['date']; ?&gt;
      
          

          &lt;?php endforeach; else: ?&gt;
          

           <h1 id="news">Keine aktuellen News.</h1>
            
          &lt;?php endif; ?&gt;
          
          </article>

My controller calls the method :

Code:

function index()
    {
    
      $data = array(
      'title'           => 'Aktuell'.$this->config->item('pageTitle'),
      'metaDescription' => 'Aktuell',
      'metaKeywords'    => 'Aktuell, '.$this->config->item('pageMetaKeywords'),
      'mainnav'         => 'aktuell',
      'subnav'          => '',
      'subsubnav'       => '',
      'hasSubnav'       => true
    );
    
    
    
    $data['posts'] = $this->posts_model->getactivePosts();
      $this->load->view('v-aktuell', $data);
    }

and the modell looks like the code you posted above.
Now still nonactive posts are shown
don get it why..

best regards