Hi,
I would like to know if the following is possible...
First, I run a query on my database mysql_query("select blah blah ..."). I then want to perform some calculations based on the fields in the returned resource, and save these values in newly created fields for each row of the resource. Is this possible?
I want to do this because I would like to sort the database based on these calculated fields.
The other way to do this would be to save the calculated values in the database itself. Then when I do the query, I'll get these fields as part of the returned resource. I don't want to do this since it takes up space in the database.
Can anyone share some gems of wisdom on this.
Thanks!
Linear Mode
