php - How to get all rows data in single row in codeigniter -

php - How to get all rows data in single row in codeigniter -

i having mysql table "users" 2 fields

1. id 2. name

i fetching records in codeigniter like,

id name 1. jhon 2. martina 3. rob

but want results in single row like,

"john,martina,rob"

try this:

$this->db->select('group_concat("name") all_names', false)->from('table')->get()->row_array();

php mysql codeigniter