Formatting database results

[eluser]bigtony[/eluser]
[quote author="Madmartigan1" date="1253309327"]I have to say bigtony, I disagree with you. Imagine what a mess a view file would be that had to preform many different string functions on several fields per result.[/quote]
All you've done is move the "mess" out of the view and into somwwhere else.

Your code:

Code:

foreach($result as $row)
{
    $row['name']       = uc_words($row['name']);//example
    $row['comment']    = htmlentities($row['comment']);//example
    $data['my_data'][] = $row;
}

In the view instead:

Code:

<?php foreach($result->result() as $row): ?>
    <tr>
        <td>&lt;?php echo uc_words($row{'name']); ?&gt;</td>
        <td>&lt;?php echo htmlentities($row['comment']); ?&gt;</td>
    </tr>
&lt;?php endif; ?&gt;

Doesn't look any messier to me...