I have a mysql table of say 20 records.
I want to make a calculation to records 19 and 20 (add, subtract, multiple, divide, etc..) on the web page into a separate variable (not in SQL - variable 21) for each table row.
How would I re-create that page sorting the table by that calculated variable (Variable 21)? I'm looking at doing a multi-dimentional array, but I have way too many fields for that to be practical. I'd like to do this dynamically. Any thoughts?