Get object from id

I do not have your table layout, but i believe you have a table called joueurs and in there a field called name.

My understanding is that if you do not specify the field names   select('*')  , the sql query will return  all the column headers.

You could do this:

PHP Code:

function get_all_statistics()
{
   $this->db->select([
                  'statistics.stat_id',
                  'statistics.leg_id',
                  'statistics.darts',
                  'statistics.finish',
                  'statistics.reste',
                  'statistics.max',
                  'joueurs.id',
                  'joueurs.name'
]);
   $this->db->from('statistics');
   $this->db->join('joueurs', 'joueurs.id = statistics.player_id');
   return $query = $this->db->get()->result();
} 


Then in your view you should simply refer to them as:

PHP Code:

{% for stat in statistics %}
   <tr>
       <td>{{stat.stat_id}}</td>
       <td>{{stat.leg_id}}</td>       
       <td>{{stat.name}}</td>
       <td>{{stat.darts}}</td>
       <td>{{stat.finish}}</td>
       <td>{{stat.reste}}</td>
       <td>{{stat.max}}</td>
   </tr>
{% endfor %} 


Oh no I'm so dumb  . I was stuck 1 week for such a stupid thing lol. Thank you very much. Yes, just using stat.name works.