Getting a sum total

[figuringout]

I get a result from a MySQL db, the result has some html tags and a pound sign in. I'd like to add all the results together and get a total, but I'm not sure exactly how I do it. The code here simply adds the last result to itself, I'd like a total of all the results.

$query2="SELECT text FROM orders_total where  orders_id = " . $orders_id .  " and text like '%<b>%'";
$result2=tep_db_query($query2);
while($nt=mysql_fetch_array($result2))
{
	$nt = str_replace("£", "", $nt);
	echo strip_tags("$nt[text]");

	$val1= strip_tags("$nt[text]");
	$sum=$val1 + $val1;
	}
print ' order object was created  ' . $orders_id .  '<br>' ;
		}
				}
echo $val1;

 

[rhodesa]

You want to keep adding to $sum with: $sum += $val1, then display $sum at the end

 

<?php
$query2="SELECT text FROM orders_total where  orders_id = " . $orders_id .  " and text like '%<b>%'";
$result2=tep_db_query($query2);
while($nt=mysql_fetch_array($result2))
{
$nt = str_replace("£", "", $nt);
echo strip_tags("$nt[text]");
$val1= strip_tags("$nt[text]");
$sum += $val1;
}
print ' order object was created  ' . $orders_id .  '<br>' ;
}//Where are these coming from?
}//Where are these coming from?
echo $sum;
?>

[The Little Guy]

$query2="SELECT text FROM orders_total where  orders_id = " . $orders_id .  " and text like '%<b>%'";
$result2=tep_db_query($query2);
while($nt=mysql_fetch_array($result2))
{

	$nt = str_replace("£", "", $nt);
	echo strip_tags("$nt[text]");

	$val1= strip_tags("$nt[text]");
	if(!$su){$sum = array_sum($nt);$su=TRUE;}
	}
print ' order object was created  ' . $orders_id .  '<br>' ;
		}
				}
echo $val1;

[figuringout]

Thanks you guys - so so simple when you know how!

 

thanks again