Welcome Guest, Not a member yet? Register   Sign In
UPDATE ERROR
#1

[eluser]glenconde[/eluser]
Help Igniter's..
I get this error when i run this code to update my database table:


A Database Error Occurred
Error Number: 1054

Unknown column '1' in 'where clause'

UPDATE `employee_logs` SET `logout_time` = '20:05:46' WHERE `1` IS NULL


THIS IS MY CODE:
Code:
function logout()
{
  $this->db->get('employee_logs');
//  $this->db->order_by("person_id", "desc");
  $person_id = $this->session->userdata('person_id');
  $logout_time = $this->session->userdata('logout_time');
  $this->session->sess_destroy();
  
  $data = array (

  'logout_time' =>date('H:i:s')

  );



  $this->db->update('employee_logs', $data, "person_id = $person_id" AND "logout_time = 00:00:00"); <--- is this wrong?

  
  redirect('login');
}
#2

[eluser]achilleusrage[/eluser]
Hi. Your double quotes in the third parameter for $this->db->update() are wrong.
Your code:
Code:
"person_id = $person_id" AND "logout_time = 00:00:00"
...evaluates to 1.

You want to do:
Code:
$this->db->update('employee_logs', $data, 'person_id = $person_id AND logout_time = 00:00:00');

// or, more to write but easier to follow in my opinion.
$this->where("person_id",$person_id);
$this->where("logout_time","00:00:00");
$this->db->update('employee_logs', $data);
#3

[eluser]glenconde[/eluser]
Thank's!

I get the Idea now..

Code:
$this->db->where('person_id', $person_id);
$this->db->update('employee_logs', $data, "logout_time = 0");




Theme © iAndrew 2016 - Forum software by © MyBB