php - Syntax error on ci model -

php - Syntax error on ci model -

i have little problem insert query codeigniter reason saying syntax error check manual corresponds mysql server version. thought did every thing right looks ok me not sure.

i thought way.

public function database() { $data['db_prefix'] = $this->db->dbprefix; $data['username'] = $this->input->post('username'); $data['email'] = $this->input->post('email'); $data['password'] = $this->input->post('password'); $this->db->query("delete `" . $data['db_prefix'] . "user` user_id = '1'"); $this->db->query("insert `" . $data['db_prefix'] . "user` set user_id = '1', user_group_id = '1', username = '" . $this->db->escape($data['username']) . "', salt = '" . $this->db->escape($salt = substr(md5(uniqid(rand(), true)), 0, 9)) . "', password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($data['password'])))) . "', status = '1', email = '" . $this->db->escape($data['email']) . "', date_added = now()"); }

status reserved word in mysql http://dev.mysql.com/doc/refman/5.1/en/show-status.html

wrap status in insert query ``

$this->db->query(" insert `" . $data['db_prefix'] . "user` set user_id = '1', user_group_id = '1', username = '" . $this->db->escape($data['username']) . "', salt = '" . $this->db->escape($salt = substr(md5(uniqid(rand(), true)), 0, 9)) . "', password = '" . $this->db->escape(sha1($salt . sha1($salt . sha1($data['password'])))) . "', `status` = '1', email = '" . $this->db->escape($data['email']) . "', date_added = now() ");

php codeigniter