Removing the keys from result_array()

Removing the keys from result_array() - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Removing the keys from result_array() (/showthread.php?tid=41324)

Removing the keys from result_array() - El Forum - 05-04-2011

[eluser]matula[/eluser]
This is probably a simple task, but I want to generate a single-level array from a resultset. This code:

Code:
$query = $this->db->select('id')->from('table')->get();

return $query->result_array()

... produces an array with "id" as the key. But I'd like to return a flat array like: array(3,5,8,12,etc)

Is there a way to do that in CI or PHP, or will I need to just loop through the array and create it myself like:

Code:
$myarray = array();

foreach($query->result_array() as $result){

  $myarray[] = $result['id'];

}

Thanks!

Removing the keys from result_array() - El Forum - 05-04-2011

[eluser]jwburnside[/eluser]
I believe PHP has a function to cover you there, called array_values():

http://php.net/manual/en/function.array-values.php

Removing the keys from result_array() - El Forum - 05-04-2011

[eluser]jwburnside[/eluser]
Actually, I'm sorry, I misunderstood the question. That will just create numerical keys. As far as I know you will have to loop through to array to get what you want.

Removing the keys from result_array() - El Forum - 05-04-2011

[eluser]Coode[/eluser]
This is something I didn't try out myself, but give it a shot!

Code:
&lt;?php

   $r = blah blah->result_array();

   $ids = array_map('intval', array_map('end', $r));

?&gt;

The variable would be array(1, 2, 3, 4). Smile