Amending result_array

[eluser]CinoGenX[/eluser]
Hi @ all

In my model I'm trying to amend values in an array generated from a phpbb query before passing back to my controller....

i.e.
$sql = "SELECT post_id, post_subject, post_text, bbcode_uid, bbcode_bitfield, bbcode_options FROM phpbb_posts WHERE .......";

$query = $this->db->query($sql);

I now want to foreach through the results and change the post_text using the phpbb3 function "generate_text_for_display".

Can someone help me out on this please....banging my head on the table on this one.

Many thanks.