get_where question

[eluser]Fenix[/eluser]
I am trying to write a query with CI where I want to select all posts in a database that have the status (an enum data type) of anything but "deleted". How would I write this code?

Code:

$this->db->select('post_id,title,name,type,status,description');
return $this->db->get_where('posts', array('post_status' != 'deleted'))->result();

I assume what I have (!=) is wrong. What is the correct way to do this?
Other statuses are "published" or "private".

Thanks!

[eluser]Colin Williams[/eluser]
Include the != in the array key:

Code:

$this->db->get_where('posts', array('post_status !=' => 'deleted'))->result();

Double-check the docs if you are unsure.

[eluser]onsetrese[/eluser]
tnx a lot, that answers our question of how to have a negation in get_where function