Returning an array to echo from sql query

Question

The second echo, for user_name, prints correctly, but the first will only print array and give 'array to string error'.

My query should return an array of about 6 names.

Is there something I'm missing that is causing it not to be returning an array correctly or how can I tweak this so I can choose which $single_name to echo?

function get_all_names(){
    $this->db->select('username');
    $this->db->from('users');
    $Query = $this->db->get();
    $rows = $Query->result_array();
    return $rows;
}

 $all_names = array();
 $all_names = self::get_all_names();
 // $single_name = $all_names[1]; 
 // Above line did not work, I needed to add in ['username'] to it. 
 $single_name = $all_names[1]['username'];
 $user_name = ($_SESSION['username']);

 echo "<script type='text/javascript'> alert( '{$single_name }'); </script>";
 echo "<script type='text/javascript'> alert( '{$user_name }'); </script>";

print the result using print_r($single_name) and check whether the result is an array or simple value? — Ramaraju.d
– Ramaraju.d, Commented Jan 31, 2013 at 13:03
Does it work now? What do you get when you use var_dump($all_names); — Wezy
– Wezy, Commented Jan 31, 2013 at 13:03
Check this link it might help you stackoverflow.com/questions/11510398/… — Ramaraju.d
– Ramaraju.d, Commented Jan 31, 2013 at 13:13
FIXED, I needed to change the line - $single_name = $all_names[1]; TO $single_name = $all_names[1]['username']; Thanks for your help guys — KeithC
– KeithC, Commented Jan 31, 2013 at 14:24

Jonny C · Accepted Answer · 2015-05-04 19:17:13Z

0

Change

$single_name = $all_names[1]

to

$single_name = $all_names[1]['username'];

answered May 4, 2015 at 19:17

Jonny C

1,9373 gold badges21 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Returning an array to echo from sql query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related