+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: [Solved] Last Logged In Query Update (/showthread.php?tid=61013)
[Solved] Last Logged In Query Update - El Forum - 08-29-2014
[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') . "'
");[Solved] Last Logged In Query Update - El Forum - 08-29-2014
[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);