Hi, I have a database with transaction data, transactions are basically cash and assets, so cash in/out (positive or negative) and asset purchase or sale (positive or negative).
I would like to display a table showing the transactions and the running total. How can I do that? I am not sure whether to try to do it in SQL and just display the result using PHP or to use SQL to retrieve the transactions and calculate the running total in PHP. Any help would be much appreciated Thanks Mick
