+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: how to use IS NULL? (/showthread.php?tid=67783)
how to use IS NULL? - falcon812311 - 04-08-2017
Hi,
I have problem with my query, its not update my table
*I want select NULL col with limit then update the DB.
this is my code model:
PHP Code:
function SetUserTakenStock($data, $id, $totalTaken)
{
$this->db->trans_start();
$this->db->select('*');
$this->db->from('user_id');
$this->db->where('status IS NULL');
$this->db->set('status', $data);
$this->db->where('user_id', $id);
$this->db->limit($totalTaken);
$this->db->update('gen_set');
$this->db->trans_complete();
if ($this->db->trans_status() === TRUE)
{
return true;
}
else
{
return false;
}
}
RE: how to use IS NULL? - janudewangga - 04-09-2017
(04-08-2017, 09:37 PM)falcon812311 Wrote: Hi,
I have problem with my query, its not update my table
*I want select NULL col with limit then update the DB.
this is my code model:
PHP Code:function SetUserTakenStock($data, $id, $totalTaken)
{
$this->db->trans_start();
$this->db->select('*');
$this->db->from('user_id');
$this->db->where('status IS NULL');
$this->db->set('status', $data);
$this->db->where('user_id', $id);
$this->db->limit($totalTaken);
$this->db->update('gen_set');
$this->db->trans_complete();
if ($this->db->trans_status() === TRUE)
{
return true;
}
else
{
return false;
}
}
I think that should be :
Code:
$this->db->where('status', null);RE: how to use IS NULL? - dave friend - 04-09-2017
Not related to the answer but this code
PHP Code:
if ($this->db->trans_status() === TRUE)
{
return true;
}
else
{
return false;
}
Can be expressed with a lot less typing
PHP Code:
return $this->db->trans_status();