CODEWITHSUNDEEP
phpcodeigniter
Tushar Gaurav
Tushar Gaurav

Reputation: 506

As I am adding select statement in this query it returns nothing?

as i am running this query with select statement its returning nothing.

$this->db->select('emp_edu.qual_id','qual_title','pass_year','institute','percentage');
$this->db->from('emp_edu');
$this->db->join('qualification_mas', 'emp_edu.qual_id = qualification_mas.qual_id', 'INNER');
$this->db->where('emp_edu.emp_id', $empID);
$this->db->where('emp_edu.del_flag', 0);
$this->db->where('qualification_mas.del_flag', 0);
$query = $this->db->get();
return $query->result();

Upvotes: 0

Views: 61

Answers (2)

tomexsans
tomexsans

Reputation: 4527

$this->db->select( array('emp_edu.qual_id','qual_title','pass_year','institute','percentage'));

or you could enclose your parameter in array

Upvotes: 0

Ahmed Gaber
Ahmed Gaber

Reputation: 708

Change 

$this->db->select('emp_edu.qual_id','qual_title','pass_year','institute','percentage');

to 

$this->db->select('emp_edu.qual_id,qual_title,pass_year,institute,percentage');

as you can see in system\database\active_rec.php line 77

if (is_string($select))
            {
                $select = explode(',', $select);
            }

Upvotes: 1

Related Questions