Simple Math With Array Elements

[scriderpsd]

It's been a while since I had to do anything like this and I'm at a road block.

Here's the scenario...

I have a DB column (original_cost) which contains numbers with or without a dollar sign. I need to be able to perform some math (sum, averages, etc) on this column.

I have pulled the data out into an array so that it could formatted on the screen...

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


	echo '<tr>';
		echo '<td><input type=checkbox></td>';
		echo '<td>'.$row['po_number'].'</td>';
		echo '<td>'.$row['description'].'</td>';
		echo '<td>'.$row['vendor_name'].'</td>';
		echo '<td>'.$row['original_cost'].'</td>';
		echo '<td>'.$row['fund'].'</td>';
		echo '<td>'.$row['program'].'</td>';
		echo '<td>'.$row['object_code'].'</td>';
	echo '</tr>';



}

I then use ereg_replace to get rid of the dollar signs....

$clean_cost=ereg_replace('\\$', '', $row['original_cost']);

But I'm at a loss on how to totall up all the clean costs to get a total cost. Any help is much appreciated.

Thanks,

Scott

[leatherback]

How about..

$sum = 0;

while()
  {
//.....

  $clean_cost=ereg_replace('\\$', '', $row['original_cost']); 
  $ sum = $sum + $clean_cost;
  }

[laserlight]

Incidentally, it may be worthwhile to "clean" them up in the database itself so that you can perform a SUM aggregate to get the answer without having to use a loop in PHP.

Also, if you must use a loop in PHP, it is probably simpler to just use str_replace() instead of ereg_replace() (not to mention that you should be using preg_replace() instead to begin with) since the numbers are not supposed to have $ symbols embedded in them anyway.