php codeigniter中的concat空间无法正常工作

Question

My select query is always prompting an error even i already put a FALSE at the end of it.

function preparedBy($series){
    $this->db->select('CONCAT (users.FirstName,' ',users.MiddleName,' ',users.LastName) as name',FALSE);
    $this->db->from ( 'users' );
    $this->db->join ( 'entry ', 'entry.ClericalAide = users.UserName');
    $this->db->where ( 'entry.Series', $series);
    $query = $this->db->get();
    return $query->row_array();
}

this is the error as i hover in my sql select

Answer 1

Your quotes are all messed up. Try running this:

function preparedBy($series){
    $this->db->select('CONCAT (users.FirstName, users.MiddleName, users.LastName) as name',FALSE);
    $this->db->from ('users');
    $this->db->join ('entry','entry.ClericalAide = users.UserName');
    $this->db->where ('entry.Series', $series);
    $query = $this->db->get();
    return $query->row_array();
}