'concat space in php codeigniter not working

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 enter image description here

phpcodeigniter


Solution 1:[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();
}

Solution 2:[2]

Try changing your function to 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();
}

Solution 3:[3]

Just add " " and not ' '.

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();
}

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 theomessin
Solution 2 urstrulyani
Solution 3 Eric Aya

Related Questions