Formatting columns in a table

[eluser]skypanther[/eluser]
I'm pulling data from a database then outputting it in an HTML table. That part's fine. But what I can't figure out is how to apply formatting to the individual columns in the results.

So, the first column is a part number, then a product name, then a price, etc. I want to format the price column as money (applying the money_format() or similar function).

My controller:

Code:

// call my model's function to grab the data:
$data['results'] = $this->productsmodel->get_products();
// load the HTML Table Class
$this->load->library('table');
$this->table->clear();
$this->table->set_heading('Part #', 'Name', 'List price', 'Parts', 'Hours', 'Total');
$this->template->set('title','Products');
$this->template->load('template','products', $data);

And my view:

Code:

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

Works fine but how can I format columns? I tried manually adding rows with $this->table->add_row() but I can't figure out how to extract the data returned by my model. BTW, it's just calling $query = $this->db->get('parts'); I could do the formatting with jQuery but there are a lot of rows and that would be slow I'm guessing.

Thanks,
Tim