title: Codeigniter Where clause
body: <p>Somehow its a bit difficult to for me to build a query like this:
  Give me all entries of navigation where linkname not null </p>
  
  <pre><code>$query = $this-&gt;db-&gt;get_where('navigation',array('linkname'!==NULL));
  </code></pre>
  
  <p>Giving me Error</p>
  
  <blockquote>
    <p>Unknown column '0' in 'where clause'</p>
    
    <p>SELECT <code>linkname</code>, <code>idnavigation</code> FROM (<code>navigation</code>) WHERE <code>0</code> = 1</p>
  </blockquote>
  
  <p>Any hints with this?</p>