Adding up all looped values

[macca_25]

Hi all,
If i have the following:

foreach($_SESSION['cart'][$i]['1'] as $value) {
$sql_2 = mysql_query("select spec_price from specs where spec_id=$value"); 
while ($row = mysql_fetch_array($sql_2)){ 
$spec_price = $row['spec_price'];
}
} 

how do i add up all the values from the while loop?
Do i have to turn the resluts into a number, at the moment they are from a column in the mySQL database that has VARCHAR assigned to it.
Cheers,
macca_25

[poison]

Do i have to turn the resluts into a number,

you don't have to but I'm used to extensive casting sin I come from a strong typed language...and at least I consider it good coding style...

at the moment they are from a column in the mySQL database that has VARCHAR assigned to it.

gg VARCHAR for an number ? odd

$total_price=0;
foreach($_SESSION['cart'][$i]['1'] as $value) {
$sql_2 = mysql_query("select spec_price from specs where spec_id=$value"); 
while ($row = mysql_fetch_array($sql_2)){ 
$spec_price = floatval($row['spec_price']);
$total_price+=$spec_price;
}
} 

[Weedpacket]

Or you could just save yourself the effort and

select sum(spec_price) as total_price from specs where spec_id=$value

But you're really gonna have to change that field type.