• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to use IS NULL?

#1
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;
 
   }
 
 
This is me. JK not me.
Reply

#2
(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);
Reply

#3
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 Rolleyes

PHP Code:
return $this->db->trans_status(); 
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.