Problems creating an SQL query - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11) +--- Thread: Problems creating an SQL query (/showthread.php?tid=72548) |
Problems creating an SQL query - desbest - 01-04-2019 Hello I'm having problems with an SQL query I'm trying to do with CodeIgniter Code: $comments = $this->db The problem is that I am using 2 NOT queries on posts.nodeview, and only one of them is being applied. How can I make the query work? RE: Problems creating an SQL query - jreklund - 01-04-2019 I can only see one of them: 'posts.nodeview !=' Are you meaning this? 'posts.nodeview =' RE: Problems creating an SQL query - Wouter60 - 01-04-2019 PHP Code: $this->db This will select the records where posts.nodeview is not 'article' and not 'pm'. Is that what you need? |