[solved] Who does see why group_by-field doesn't get in the view?

[eluser]Jan_1[/eluser]
I don't see it... :roll: Do you?
I wrote a dozend payments for 3 different persons in the database.
Now I want to see the sum per person. I get the sum, but not the persons name. Why that?
Thank you for a little help..!!

A PHP Error was encountered
Severity: Notice
Message: Undefined property: stdClass::$user_name

View:

Code:

...
<?php if (isset($ks_auslagesummen))
      { foreach($ks_auslagesummen as $op):?>
        <tr>
          <td>&lt;?=$op->user_name?&gt;</td>
          <td>&lt;?=$op->value_sum?&gt;</td>
        </tr>
&lt;?php endforeach;
      }?&gt;
...

Controller:

Code:

...
        $data['ks_auslagesummen'] = $this->kasse_model->get_ks_auslagesummen();
        $this->load->vars($data);
...

Model:

Code:

function get_ks_auslagesummen()
    {
      $this->db->select('SUM(ks_value) AS value_sum','user_name');
      $this->db->group_by('user_name');
      $this->db->from('ks_table');
      $query = $this->db->get();
      if ($query->num_rows() > 0) { $data = $query->result();}
      return $data;
    }

print_r($ks_auslagesummen); says: "Array ( [0] => stdClass Object ( [op_summe] => 265.44 ) ) "

[eluser]davidbehler[/eluser]
try

Code:

function get_ks_auslagesummen()
    {
      $this->db->select('SUM(ks_value) AS value_sum', FALSE);
      $this->db->select('user_name');
      $this->db->group_by('user_name');
      $this->db->from('ks_table');
      $query = $this->db->get();
      if ($query->num_rows() > 0) { $data = $query->result();}
      return $data;
    }

Why is there a property 'op_summe' anyway? shouldn't that be 'value_sum'?

[eluser]Jan_1[/eluser]
Thank you!!!, Waldmeister. That's, it (again. :red: )