使用codeigniter从数据库返回两行

Question

This query works as I want but only returns one value.

public function get_doctor_name($doctor_id)  {
  $result = $this->db->query("SELECT first_name, last_name from doctors where id= $municipio_id")->row_array();
  return $result['first_name'];
}

How to return the last_name as I did for first_name in the same query?

Answer 1

Your query is actually correct.

However, you can use return $result->result_array(); to get an array of all fields, first_name, last_name etc.