Codeigniter num_row returns "array" instead of number

Question

Alright, Im trying to count all the rows where "Membership_Status" = Active. The result I get right now is "Array" instead of a number.

Here is my model

class Report_model extends Model
{
 function count_members()
 {
  $query = $this->db->get_where('Membership', array('Membership_Status' => 'Active'));
  return $query->num_rows();
 }


}

Here is my controller

class Report extends Controller {

 function YTD_report()
 {

     $data['main_content'] = 'report_membership_view';
        $this->load->view('includes/template', $data);


 }

}

Here is my view

report_model->count_members();
echo $total;

?>

My result is Array, where according to the db info, it should be 4.

What can I do/change to get it to display the proper number?

thanks

t00ny · Accepted Answer · 2010-07-29 03:03:31Z

1

the $data array your passing to the view will create one variable for each key to be used by view...

So your controler once the model is loaded, you should do:

$data['total'] = $this->Report_model->count_members();

Then in the view you can use the $total variable like this:

<?php echo $total; ?>

edited Jul 29, 2010 at 3:03

answered Jul 29, 2010 at 2:57

t00ny

1,6481 gold badge12 silver badges8 bronze badges

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

1 Comment

t00ny Over a year ago

Glad I could help... I don't use codeigniter myself so I wasn't 100% sure that would do the trick :)

Collectives™ on Stack Overflow

Codeigniter num_row returns "array" instead of number

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related