Welcome Guest, Not a member yet? Register   Sign In
[Solved] Last Logged In Query Update
#1

[eluser]riwakawd[/eluser]
Hi, I have problem with my update query. I can not seem to figure out the correct places for my quotes. if that's the cause of it not working? I have autoloaded the date helper.

The date_added not working?

Error Message Parse error: syntax error, unexpected '=' in C:\Xampp\htdocs\codeigniter\project-1\application\libraries\user.php on line 19

Code:
$this->CI->db->query("UPDATE " . $this->CI->db->dbprefix . "user
SET last_logged = " . date_added = NOW() . " // Not working
WHERE user_id = '" . (int)$this->CI->session->userdata('user_id') . "'
");
#2

[eluser]riwakawd[/eluser]
Found simple way sort of what I am after

Code below working now.

Code:
$now = date("Y-m-d H:i:s");

$data = array(
'last_logged' => $now
);

$this->CI->db->where('user_id', $this->user_id);
$this->CI->db->update('user', $data);




Theme © iAndrew 2016 - Forum software by © MyBB