airick10 0 Newbie Poster

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.