Adding two columns of different rows

[Pradeep_Chinna]

please help me out...

 

How to get this (img.jpg) type of result.

 

I have 4 columns namely, ID, NEW, AMOUNT, TOTAL.

please see my image attachment to understand easily.

 

for first row, TOTAL= AMOUNT,

for 2nd row, TOTAL=  AMOUNT(ROW1) + AMOUNT(ROW2) OR AMOUNT(ROW2) + TOTAL(ROW1),

for 3rd row, TOTAL=  AMOUNT(ROW1) + AMOUNT(ROW2)+AMOUNT(ROW3) OR AMOUNT(ROW3) + TOTAL(ROW2).

and so on...

means loop will be upto the end of table.

 

I hope u understood my doubt.

 

please help me out...

 

THANK YOU.

Edited August 6, 2013 by Pradeep_Chinna

[PravinS]

refer: http://www.w3schools.com/php/php_mysql_select.asp

 

and for total value, you can define $total = 0; above while loop and then in while loop just add database total value to $total

as $total = $total + AMOUNT(ROW)

 

may this will help you

[Pradeep_Chinna]

@PravinS:

 

sorry...Not useful.

[kicken]

As you loop through the result set, add the amount for the current row to a total variable and save that variable to the row. eg:

$total = 0;
$allRows = array();
while ($row=$result->fetch()){
   $total += $row['amount'];
   $row['total'] = $total;

   $allRows[] = $row;
}

Then when you output the data in your table you'll have the total field in each row to output.