generate->table datas missing with join request

Hi everybody,

I'm facing a weird issue with the table library. I'd like to retrieve all the datas of 2 tables, and display it in a "raw table". The goal is not to display a beautiful table, but to allow people to export datas in a excel file and then work on it.

Here is the controller:

Code:

public function view_all() {

$this->load->library('table');


$this->db->from ('patient as p');
$this->db->join ('operation as o',
"o.zkf_pat = p.zkp_pat " );
$query = $this->db->get();

Template::set('query', $query);
Template::set_view('all_operations');
Template::render();

Pretty basic i guess...

And my view:

Code:

<?php

echo $this->table->generate($query);

?>

i attached a screen capture of the result. As you can see, nothing in the zkf_pat column, only the titles (fake datas of course :p ) which should be in the next one ! And same for a few others columns...

I have to say i'm a bit confused, and i don't understand why some datas are missing, but not all of them.

I checked my phpmyadmin configuration, but found nothing special for me...

Is it from the library table, or maybe somewhere else (SQL query, sql table structure...no idea !)

Thanks for your help

M.

Attached Files

Thumbnail(s)