[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') . "'
");