CodeIgniter Forums

Full Version: DB realted small Qs
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Yash[/eluser]
Code:
$data = array(
               'Activate' => 1,
               'CheckCode' => ""
            );

            
    $this->db->where(array('MemberID'=> $id,'CheckCode'=> $act_code));
    $str1 =$this->db->update('users', $data);

this works perfectly.

but problem is each time $str1 gives 1 whether it updates or not .

My question how to do this also know whether query is successful or not.

El Forum

[eluser]xwero[/eluser]
$this->db->affected_rows()

El Forum

[eluser]Yash[/eluser]
You always rocks Smile

Thank you man....I'll try