Summing records throughout the query in new column

[nielskg]

Hi,

I think the title is a little weird, so I'll exlain by an example :

My table :

id | day

1 | 4
2 | 3
3 | 3
4 | 2

Now I want a result set looking like this :

id | day | sum

1 | 4 | 4
2 | 3 | 7
3 | 3 | 10
4 | 2 | 12

So adding each "day" to the sum of the former row...

Any way to accomplish this in one (!) query?

Thanx,
Niels

[devinemke]

a simple example (assuming mySQL)

$result = mysql_query('SELECT * FROM table');
$sum = 0;

echo '
<table border="1">
<tr>
<td>id</td>
<td>day</td>
<td>sum</td>
</tr>
';

while ($row = mysql_fetch_assoc($result))
{
	$sum += $row['day'];

echo '
<tr>
<td>' . $row['id'] . '</td>
<td>' . $row['day'] . '</td>
<td>' . $sum . '</td>
</tr>
';
}

echo '</table>';