Loop through recordset and add values

[TCovert]

I need help with what should be a simple function. I want to loop through a recordset returned from a sql select statement, and add the values of field 1 from each record. But, I also want to preserve the original value of each record.

Anyway, hope this makes sense. Any suggestions would be much appreciated.

[bosco500]

This should work

$sql = "SELECT field1 FROM table1";

$addition = 0;

$result = mysql_query($sql);


while ($row = mysql_fetch_array($result)) {

	$addition += $row['field1'];

}

echo $addition;