Codeigniter Where is the item

Question

Somehow its a little difficult to create such a request for me: Give me all the navigation entries where linkname is not null

$query = $this->db->get_where('navigation',array('linkname'!==NULL)); 

Giving me errors

Unknown column "0" in the "where" section

SELECT linkname , idnavigation FROM ( navigation ) WHERE 0 = 1

Any clues with this?

Answer 1

You can simply write the WHERE manually as follows:

 $this->db->get_where('navigation', 'linkname IS NOT NULL'); 

Answer 2

It:

 $query = $this->db->get_where('navigation',array('linkname !=' => NULL)); 

Answer 3

Try this one ...

 $this->db->select("*) ->from("table_name") ->where("your_id <>",''); 

Answer 4

 $this->db->where('linkname !==', NULL); $query = $this->db->get('navigation');