Codeigniter Where clause

Question

Somehow its a bit difficult to for me to build a query like this: Give me all entries of navigation where linkname not null

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

Giving me Error

Unknown column '0' in 'where clause'

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

Any hints with this?

Dunno why this question has been downvoted. Helped me. I had `$query = $this->db->get_where('table', array('column', 'value'));` and had this issue. Needed to change `'column', 'value'` to `'column' => 'value'`. Silly error, but thanks for helping. :) — Thomas Clayson, Jun 15 '12 at 14:38
Possible duplicate [querying-mysql-with-codeigniter-selecting-rows-where-field-is-null](http://stackoverflow.com/questions/2489453/querying-mysql-with-codeigniter-selecting-rows-where-field-is-null/13995884#13995884) — None, Mar 15 '13 at 01:03

score 12 · Accepted Answer · answered Apr 11 '12 at 15:30

12

You can simply write the WHERE clause manually like this:

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

answered Apr 11 '12 at 15:30

Colin Brock

score 1 · Answer 2 · answered Apr 11 '12 at 15:33

1

It's :

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

answered Apr 11 '12 at 15:33

1

I think its important to note that there should be a space between the field name and the operator (i.e 'linkname!=' will not work) – Eric Kigathi Apr 21 '12 at 18:06

score 0 · Answer 3 · answered Dec 15 '14 at 09:22

0

Try this one...

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

answered Dec 15 '14 at 09:22

Raham

score -2 · Answer 4 · answered Apr 11 '12 at 15:30

-2

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

answered Apr 11 '12 at 15:30

csotelo

4 Answers4