Add extra columns to database generated table

[eluser]CroNiX[/eluser]

Code:

//in controller
$query = $this->db->get('field',$config['per_page'],$this->uri->segment(1))->result_array();  //original result array
foreach ($query as $key => $row )
{
    //add new columns with a value
    $query[$key]['extra_column'] = 'new_value1';
    $query[$key]['extra_column2'] = 'new_value2';
    //...
    // Note: the original data for this row is in $row if you need data from it
}
$data['records'] = $query;  //store the reformatted array to send to view

//in view
echo $this->table->generate($records);