Im having trouble converting this code to codeigniter. Please help
SELECT * FROM table1
LEFT JOIN table2 ON table2.number = table1.number
WHERE table2.number IS NULL
-
Have you looked here codeigniter.com/user_guide/database/…user4419336– user44193362016-02-02 03:17:54 +00:00Commented Feb 2, 2016 at 3:17
-
yes, cant find instructions for IS NULL.Wilnar Vincent– Wilnar Vincent2016-02-02 03:29:45 +00:00Commented Feb 2, 2016 at 3:29
Add a comment
|
5 Answers
Use below code.
$this->db->select('*');
$this->db->from('table1');
$this->db->join('table2 ', 'table2.number = table1.number','left');
$this->db->where('table2.number IS NULL');
$query = $this->db->get();
Comments
try this
$this->db->query('YOUR QUERY HERE');
example:
if($this->db->query('SELECT * FROM table1 LEFT JOIN table2 ON table2.number = table1.number WHERE table2.number IS NULL') )
{
echo 'success';
}
else
echo 'check your query';
Comments
$this->db->where('table2.number IS NOT NULL', null, false)
OR
$this->db->where(array('table2.number' IS NOT NULL));
Comments
You can do it like this.
$this->db->select('*');
$this->db->from('table1');
$this->db->join('table2 ', 'table2 .user_id = table1.id','left');
$this->db->where('table1.users_id', $id);
$query = $this->db->get();
Comments
use this:
$this->db->select('*')
->from('table1')
->join('table2 ', 'table2.number = table1.number','left')
->where('table2.users_id', NULL );
$query = $this->db->get();
