Modifying results of mysql Query in PHP

[smokefree]

Hoping someone can give me a hint as to how I can modify the results of a query
before outputting it. I'm pretty new to using OOP and mysql but as I understand it, the reqults of the query is a copy from the database stored in memory as a PHP object. Want to modify the results of the query without modifying the actual database before passing to the output class - since the output class works well, I don't want to hack it, I just want to modify the output that I pass to it. how can I do it. I hope the code snippet below makes it clear what I want to do.

// Code to connect to database initialize output class]
$result = mysql_query('SELECT time, hostname, type, uid, message FROM tablename');
//
// while($row = mysql_fetch_array($result)){
//
//  Need to store the result back into the original object so that 
//  the output class will output the modified results
//  (I don't want to change the database, just the query results before output)
//
//  $row['type'] = my_conversion_function($row['type']);  

// }
//
$table->put( $result );  // Class method call that outputs the table in html with nav buttons

Can I do this?

[big_nerd]

If the $result variable is an object you don't modify the object directly.

What I would recommend is instead of hacking the "put" code, copy the code from "put", and call it "modPut" or something to that effect.

I would recommend hacking the NEW function, to say, take an array as a function argument for the list of changes.

You can do that or, if the "conversion" can be done via SQL, you can modify your SQL statement to convert the results on the database side, verses with PHP.

[smokefree]

Thanks for the response, but I was really trying to keep the output class as a reusable generic block. I'd much rather copy and modify the result object and hack it if that is feasable. Does anyone know if it is possible to access the query result object and modify the data?