CodeIgniter Active Record not equal

Question

In CodeIgniter using active record  how do I perform a not equal to in  this- gt db- gt where     For instance    this- gt db- gt where  emailsToCampaigns campaignId    campaignId     Will do equal to  but I need not equal to   I have tried    this- gt db- gt where  emailsToCampaigns campaignId  lt  gt      campaignId    this- gt db- gt where  emailsToCampaigns campaignId        campaignId    this- gt db- gt where  emailsToCampaigns campaignId             campaignId    this- gt db- gt where  emailsToCampaigns campaignId         campaignId     All with no luck   Ideas

User · Answer

According to the manual this should work:

Custom key/value method:

You can include an operator in the first parameter in order to control the comparison:

$this->db->where('name !=', $name);
$this->db->where('id <', $id);
Produces: WHERE name != 'Joe' AND id < 45

Search for $this->db->where(); and look at item #2.

User · Answer

This should work  which you have tried    this- gt db- gt where not in  emailsToCampaigns campaignId    campaignId

User · Answer

this- gt db- gt where  emailsToCampaigns campaignId        campaignId     This should work  which you have tried   To debug you might place this code just after you execute your query to see what exact SQL it is producing  this might give you clues  you might add that to the question to allow for further help    this- gt db- gt get                    your query executing  echo   lt pre gt                        to preserve formatting die  this- gt db- gt last query         halt execution and print last ran query

User · Answer

Try this code   This seems working in my case     this- gt db- gt where array  id      gt   id

User · Answer

It worked fine with me    this- gt db- gt where  your id      your id     Or try this one    this- gt db- gt where  your id  lt  gt    your id     Or try this one    this- gt db- gt where  your id IS NOT NULL      all will work

[php] CodeIgniter Active Record not equal

Examples related to php

Examples related to codeigniter