The word "Array" gets printed instead of the values of the rows

Question

Okay,i'm a newbie to CI and MySQL. This is my code:

<?php
class Trail2 extends CI_Controller{

public function boo() {

    $this->load->database();
    $this->load->helper('html');
    $ret="SELECT * from posts";
    $query=$this->db->query($ret);
    foreach($query->result_array() as $row)
    {
        echo br(1);
        echo $row;
    }   
}

}

?>

and this returns the word "Array" in place of the values of the rows. I cant seem to figure out why though. Thanks in advance. :)

MoarCodePlz · Accepted Answer · 2011-06-18 20:24:51Z

6

use

var_dump($row);

instead of

echo $row;

and if you just want to see the values of the array you can do something like the following

for ($var = 0; $var < sizeof($row); $var++) echo $row[$var].", ";

edited Jun 18, 2011 at 20:24

answered Jun 18, 2011 at 20:14

MoarCodePlz

5,1842 gold badges27 silver badges31 bronze badges

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

Comments

knittl · Accepted Answer · 2011-06-18 20:14:41Z

5

$row is an array. use $row['column'] to access a single column. to see what the array looks like, you can use print_r($row) or var_dump($row)

answered Jun 18, 2011 at 20:14

knittl

269k59 gold badges339 silver badges405 bronze badges

Collectives™ on Stack Overflow

The word "Array" gets printed instead of the values of the rows

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related