How to write a "not equal to" expression with CodeIgniter's query builder
06:53 18 Mar 2013

I am quite confused with this error which i am receiving with this code

$this->db
    ->order_by('uid', 'DESC')
    ->where('type!=', "Admin")
    ->get('user_profile', $config['per_page'], $this->uri->segment(3));

Here is what I get the Error

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Admin' ORDER BY `uid` DESC LIMIT 10' at line 3

SELECT * FROM (`user_profile`) WHERE `type!=` 'Admin' ORDER BY `uid` DESC LIMIT 10

Filename: C:\wamp\www\proposal\system\database\DB_driver.php

Line Number: 330

php codeigniter where-clause query-builder quoting