complex sort

[spooke2k]

Hi i have a table i need to sort information into via the total cost, now i cant do certain calculations easly in mysql because of the varying variables depending on what it brings back, so im using php to work the calculation out on the webpage.  But i want to display the information in a table in desc order from total cost.

 

So say i have 4 results 

 

A=10

B=11

c=1

D=-10

 

i need to find a way play them in order of the total i worked out.

 

I know i can stick the results into an array after i worked out the calulations

but im not sure best way to sort them once i have them in an array.

 

Thanks

 

Spooke2k